Regular Expression - Parse CSV

[Guest]

"Q-Accept, Other Employment"
I need to remove the "," from the above string. The CSV File I have includes commas inside quotetaion marks, I need to remove the comma and leave the string intact. Any help with te rereplace format would help

Thanks

Andy

[Guest]

Try this: <cfset string = "Q-Accept, Other Employment" />
<cfset modifiedString = ReReplace(string, '["]', '', 'ALL') />

[Guest]

I think the previous poster may have a typo in the example code.

Try changing this...
<cfset modifiedString = ReReplace(string, '["]', '', 'ALL') />
to this...
<cfset modifiedString = ReReplace(string, ',', '', 'ALL') />

Good luck!