Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Splitting comma Seperated value and storing in temporay variable in workflow

Avatar

Level 2

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 ?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 2

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 2

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.