Splitting comma Seperated value and storing in temporay variable in workflow

[Parth1]

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 ?

[Anasso1337 · Accepted solution]

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.