Forum Discussion

jdsnap's avatar
jdsnap
New Contributor II
4 years ago
Solved

Parsing a string into 2 columns

Hi, I am trying to parse a list I am getting and putting it into 2 columns. My value is $email is (xyz@test.com, abc@de.com, 13432@me.com) What I want to accomplish is parse out $email into two ...
  • tlikarish's avatar
    tlikarish
    4 years ago

    Ah, sorry, misunderstood the requirement.

    In that case, you could do something like this:

    $email.split(',')[0] โ†’ primary
    $email.split(',').slice(1).join(',') โ†’ secondary

    Hereโ€™s an example pipeline to play around with if itโ€™s helpful.

    split-example_2022_04_06.slp (4.9 KB)