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 ...
Forum Discussion
Thanks for the suggestion tlkarish and that wasn’t exactly what I was looking for. Sorry for not being clear.
Using example $email is (xyz@test.com, abc@de.com, 13432@me.com)
I would like to return the following
$primaryEmail - xyz@test.com
$secondaryEmails - abc2de.com, 13432@me.com
Thanks in advance.
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)
Thanks for both of your help.
