5 Replies Latest reply on Jan 11, 2017 4:17 AM by Sam Lynn

    Need assistance splitting a comma delimited string

    Sam Lynn

      Hi everyone,

       

      I am having trouble splitting a comma delimited string field.

       

      The field looks something like this: CA,1922PO,1818CC,BC4411

       

      I'm trying to create a new field that returns only 1818CC.

       

      Please note that the field has an inconsistent number of commas/values and therefore I need to basically say, find CC and return CC and the associated numbers which are 1818 in this example (and that I can't have any of the commas included).

       

      The inconsistent number of commas and values is causing me the trouble. I have tried using a combination of the FIND() and TRIM() functions but have had no luck.

       

      Appreciate anyone being able to help.

       

      Thanks