Best Practice to Remove Whitespace
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
Hi Jason,
what about applying the RTRIM function at the View level via a Virtual Table:
Hi Jason,
what about applying the RTRIM function at the View level via a Virtual Table:
Reply URL
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
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
Hi Jason,
wow, that's great to hear, sounds exciting actually - thanks for letting me know!
regards,
David
Hi Jason,
wow, that's great to hear, sounds exciting actually - thanks for letting me know!
regards,
David
Replies have been locked on this page!