I have CSV files that contain double quoted columns with embedded commas.  I'd like a command line utility I can call w/the relevant regex to remove them, but I can put that together if I can get the right regular expression.  I'm close, but it only seems to work on a single line file using grepWin for testing. The regex have ...

Thanks a lot to MRAB and Susan... It work great!!!.  I have googled a lot for a solution for with no result. Probably this is the only post solving this. Now, I can fix the google contacts csv export file (, separated and quoted notes with \r\n inside) for a excel .csv readable (; separated in spain, with quoted fields with \r ...

Hello, I am using the Javascript flavoured "Microsoft VBScript Regular Expressions 5.5" COM object in VB6 to search for a list of numbers in a CSV string that is made up of 2-digit zero-filled numbers. The CSV string could contain thousands of values. This is a sample of the ...

Hello, I am looking to figure out if it is possible to seach a CSV file to find a match for a field in a certain position.  I am searching through transaction files that contrain lines that look like ...

The problem: Peachtree 2008 exports CSV data and does not escape double quotes inside double quotes.  When I import the CSV into MySQL it splits up the fields incorrectly and creates problems with some rows. I'm trying to build a regular expression to remove the double quotes that appear inside of a field with double quotes. Example ...