How to generate derived variables with delimiter for email addresses

[Wandrews]

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]

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.