SnapLogic - Integration Nation

jdsnap · ‎03-31-2022

Hi, I am trying to parse a list I am getting and putting it into 2 columns.

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.

tlikarish · ‎04-06-2022

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.

jdsnap · ‎04-06-2022

Thanks for both of your help.

Parsing a string into 2 columns