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.