Ask Your Question
1

Remove whitespace from value

asked 2019-07-03 10:34:54 -0500

CaptinCCat gravatar image

updated 2019-07-15 15:33:09 -0500

Hi all, i am trying to remove white space from the values withing the field colums.

Some of our data has a bunch of white space in it like "Alice " and we want it to just be "Alice"

Can someone help me with a way to remove this extra space?

I have found multiple ways to edit the column names, but thats about it.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2019-07-12 17:13:40 -0500

CaptinCCat gravatar image

updated 2019-07-12 17:15:15 -0500

metadaddy gravatar image

Using an Expression Evaluator, enter the following in the field expression

${str:trim(record:value('/FIELD'))}

where /FIELD is the field you want to trim

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2019-07-03 10:34:27 -0500

Seen: 606 times

Last updated: Jul 15