leading and trailing whitespaces from field? | Community
Skip to main content
G
god_prophet
New Participant
September 24, 2023
Solved

leading and trailing whitespaces from field?

  • September 24, 2023
  • 1 reply
  • 842 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by _Manoj_Kumar_

Hello @god_prophet 

 

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

 

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

1 reply

_Manoj_Kumar_
_Manoj_Kumar_Accepted solution
New Participant
September 25, 2023

Hello @god_prophet 

 

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

 

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

     Manoj     Find me on LinkedIn
    Terms & ConditionsAccessibility statement

    Loading footer...