Philip Newton <[email protected]> writes:
> On Tue, Mar 24, 2009 at 12:43, Mads Ruben Rennemo <[email protected]> wrote:
>> Also, when I save you as a CSV, I expect a line break inside a cell to
>> be removed or converted. I don't expect to see two 8-column lines in
>> my 16-column CSV file.
>
> I think the main hate is considering "CSV" to have exactly one
> referent... everyone bakes their own little soup.
>
> In Excel's little sub-dialect, for example, quotation marks around a
> field escape not only the field delimiter but also the record
> delimiter.
That's entirely correct behaviour. Quoth RFC 4180 §2.6:
Fields containing line breaks (CRLF), double quotes, and commas
should be enclosed in double-quotes. For example:
"aaa","b CRLF
bb","ccc" CRLF
zzz,yyy,xxx
If your parser can't handle this, it's unequivocally broken.
--
ilmari
"A disappointingly low fraction of the human race is,
at any given time, on fire." - Stig Sandbeck Mathisen
