How to generate derived variables with delimiter for email addresses

Wandrews

Member
Greetings All,

I have an input field string of email addresses on the spool file

i.e. [email protected];[email protected]

Does anyone know if it is possible to generate a list of data variables in director using ";" as the delimiter to split the string values into two input data variable i.e. email1 and email2

Thanks in advance!
 

KSwaeby

Reputable Poster
You should be able to do this with some UserVar logic. Off the top of my head I would do something like this...

1) Make a UsrVar to count how many delimiter chars (;) there are in the string.
2) Make UsrVar (U_Email1, U_Email2, etc) substring the 1st email address out of the original string. Substring the 2nd email address, etc.
 
Top