RegEx -Help.

[sean69]

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

[Dan_Bracuk]

If this is coming from a .csv file, try reading it with cfhttp instead of cffile.  Then you will have a query object to work with.

[JR__Bob__Dobbs · Accepted solution]

You might try looking at this function: http://www.cflib.org/udf/CSVtoArray from cflib.org.

[sean69]

hey thanks - I never thought to look, at least I can pick that apart and see how they are doing it....

-thanks

-sean