Best Practice to Remove Whitespace

Jason Kaczmarek shared this question 1 week 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