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