
14 Nov
2008
14 Nov
'08
4:11 p.m.
Jeff Dunlap wrote:
The expression regex e(",") handles files in a clean format such as:
field 1,field 2,field 3
I would like to read some CSV files where there may be fields that contain a comma (enclosed in ""):
1999,Smith, Mike, "Smith, Mike", 55 1999,Doe, Jane, "Doe, Jane", 45
And if possible, I would like to handle commas and quotes within the field:
1999,Doe, Jane, "Doe, Jane "Happy Gurl"", 45
googling regex csv yields several hits the first of which is: http://geekswithblogs.net/mwatson/archive/2004/09/04/10658.aspx Jeff