jdsnap
4 years agoNew Contributor II
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 columns in mapper $primaryEmail and $secondaryEmail
I am able design the pipeline to get primary $email.split(‘,’,1). that returns xyz@test.com
By using the search function I am able to determine the index of the first , I was then going to slice it.
$email.search(‘,’) returns 13
how to I encapsulate that in a slice?
Any suggestions ? Thanks in advance.