Splitting comma Seperated value and storing in temporay variable in workflow | Community
Skip to main content
P
Parth1
Level 2
November 6, 2023
Solved

Splitting comma Seperated value and storing in temporay variable in workflow

  • November 6, 2023
  • 1 reply
  • 1048 views

file has 2 columns:

Profile ID , subject, Marks 

1. ABC, "Maths|Geography| science", "100| 90|80"

2. XYZ, "Maths|Geography", "90|100"

 

how can i store in temporary variables and use them for personalization ?

 

Adobe campaign standard doesn't have split function which we can use for splitting string and store them in temporary variable.

We do have substring but with substring i am not able store them dynamically 

how to achieve this kind of customization in ACS ?

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 Anasso1337

Hi @parth1,

 

You can use a combination of Replace (replace pipe as line return) and GetLine functions in an enrichment to do this.

  • For example : GetLine(Replace(subject, '|', '\n'), 1) should give you the first value 'Maths' of your pipe separated string

You will have to do that for as many subjects or marks you can have at a maximum.

Also your string should NOT be above 255 chars or it will trigger an error.

 

Hope this helps.

1 reply

A
Anasso1337Accepted solution
Level 2
November 7, 2023

Hi @parth1,

 

You can use a combination of Replace (replace pipe as line return) and GetLine functions in an enrichment to do this.

  • For example : GetLine(Replace(subject, '|', '\n'), 1) should give you the first value 'Maths' of your pipe separated string

You will have to do that for as many subjects or marks you can have at a maximum.

Also your string should NOT be above 255 chars or it will trigger an error.

 

Hope this helps.

    Terms & ConditionsAccessibility statement

    Loading footer...