leading and trailing whitespaces from field? | Adobe Higher Education
Skip to main content
G
god_prophet
Level 6
September 24, 2023
Beantwoord

leading and trailing whitespaces from field?

  • September 24, 2023
  • 1 reactie
  • 844 Bekeken

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.

Er kunnen geen reacties meer worden geplaatst op dit onderwerp.
Beste antwoord door 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 reactie

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAntwoord
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
    ForumvoorwaardenAccessibility statement

    Loading footer...