Ask Your Question

Remove whitespace from value

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

CaptinCCat gravatar image

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

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

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

CaptinCCat gravatar image

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

metadaddy gravatar image

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


where /FIELD is the field you want to trim

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



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

Seen: 873 times

Last updated: Jul 15 '19