1 Reply Latest reply: Aug 13, 2012 4:39 PM by Roberto Postma RSS

    Splitting field values

      I am loading a excel file (extracted from our CRM) where the fields having multiple choice reside in the same field. See below (the last three listings)

       

      EC Printer
      EC Printer
      EC PathView
      EC Fax
      EC Overnight,EC PathView
      EC Fax,EC Overnight
      EC Fax,EC Overnight

       

      Using the last entry, EC Fax and EC Overnight need to be two unique values and no combined. How can I split these values out to correctly display the fields?

       

      Needs to be:

       

      EC Printer
      EC Printer
      EC PathView
      EC Fax
      EC Overnight
      EC Fax
      EC Fax
      EC PathView
      EC Overnight
      EC Overnight