3 Replies Latest reply on Jan 10, 2011 8:22 AM by sean69

    RegEx -Help.

    sean69 Level 1

      Hi;

       

      I'm trying to figure out how to write a quick regex to find and replace [or ignore] commas in the vaules of a comma separated list:

       

      i.e:

      "ONE","TWO","THREE" ...etc...

       

      May have a record that looks like

       

      "ONE",,"THREE,"this is, four"

       

      so I can't use ," or ", as the delimiter & a comma can show up in the data fields ...

       

      any ideas?

       

      -thanks

      -sean