Trim Space

[LuckyMe]

Let's say a have a data looks like this:

"aaaa

bbbb

ccc

ddddd"

How so I trim to be like this:

"aaaa

bbb

ccc

dddd"

I want to get grid off spaces

Thanks

[mborgens]

Make a calculation field that modifies your "data field" and use the following script:

Substitute(data field, "

[LuckyMe]

Thank you very much