2 Replies Latest reply on Apr 26, 2017 9:46 AM by cortiel

    multiple items in filed --> mulitple rords in childtable


      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