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:
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 ...
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.
hey thanks - I never thought to look, at least I can pick that apart and see how they are doing it....