Best Practice to Remove Whitespace

Jason Kaczmarek shared this question 21 months ago
Answered

Ignoring the Data Transformation Module, what is the best method for removing trailing spaces on text fields? I could setup a calculated field (RTRIM) for each of these, but that would be time consuming. I was hoping there was a better way.

Thank you,

Jason

Comments (3)

photo
1

Hi Jason,

what about applying the RTRIM function at the View level via a Virtual Table:

/8PzFp5CyuANFUAAAAASUVORK5CYII=

regards,

David

photo
1

David,

This idea will be a huge help! I didn't know what virtual tables were. Actually, this could completely change the way I prepare data.

Thank you,

Jason

photo
1

Hi Jason,

wow, that's great to hear, sounds exciting actually - thanks for letting me know!

regards,

David