Active Directory Data Pull

[Rocky_Brown]

I am pulling a list data field in from Active directory is formatted such as:

smpt:john.doe@emial.comSMPT:jdoe@email.com/:xxxxxxxxxxxxxxxxsmpt:johnd@email.com

I need to separate the field into individual fields only picking up the email addresses.

Can this be done in m-code?

Thanks,

Rocky Brown

[vicky_]

You could try split that column on "SMPT:" as a delimiter.