in reply to A better way to split CSV files with quoted strings that may contain commas?
Recently the vendor started using single quoted strings in the data like 'IBM machine' or worse 'IBM,16576523'
Although not an official standard, you may want to point your vendor to RFC 4180 or the How To or even Wikipedia. They should really be using double quotes, not single. I know most of the CSV modules support double quotes ... I wouldn't bet on them supporting single quotes.
|
|---|