leading and trailing whitespaces from field?

[god_prophet]

How to remove whitespaces, tabs, and other elements that are not part of the content of the field?

I've a column MES of the format: 202309 (for september of 2023) on format string in the schema and string in the configuration of the import activity.

I want to remove whitespaces (tabs, etc) , in order to make indexing on this column faster.  

What would be the best approache?

I'm using Campaign v7 Classic.

[_Manoj_Kumar_ · Accepted solution]

Hello @god_prophet 

You can use the RTRIM and LTRIM functions to remove whitespaces.

Documentation can be found here: List of functions | Adobe Campaign