How to generate derived variables with delimiter for email addresses


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!


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.