cortiel

multiple items in filed --> mulitple rords in childtable

Discussion created by cortiel on Apr 26, 2017
Latest reply on Apr 26, 2017 by cortiel

I have a imported table where there are multiple email address in a field separated by commas.

 

I want to split those into a childtable

 

for example

agency::email contains     "abc@yahoo.com, qwe@gmail.com,hyi@hotmail.com"

 

i want to create 3 records in contacts

 

i could use   left(email,position ....

 

i was wondering if there is a better wway to access the 3 email in one field

 

Thanks

 

Peter

Outcomes