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

    multiple items in filed --> mulitple rords in childtable

    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