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     ",,"


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