[TxMt] Re: Regular expression conundrum (CSV)

James Edward Gray II wrote:

I can tell you from experience that it's impossible to correctly parse all valid CSV with just one regular expression. The second edition of Mastering Regular Expressions gives an example pattern that gets very close, but I've found edge cases it fails on.

Well, that's not quite accurate. There is no single 'csv' spec, so there is no bright line between 'valid' and 'invalid' csv here. Most people try to conform to what MS Excel does (excel being the 800 pound gorilla in the spreadsheet market), but many other apps/people make csv that is close to, but not quite, the same as the excel format.

-Jacob