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

leading and trailing whitespaces from field?

  • September 24, 2023
  • 1 reply
  • 844 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
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
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  | https://themartech.pro
    Terms & ConditionsAccessibility statement

    Loading footer...