2009/3/24 Dagfinn Ilmari Mannsåker <[email protected]>:
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.
Thus we have a hateful spec and hateful software.
The question is do the two hates neutralize each other or combine to
form a critical mass?
--
perl -Mre=debug -e "/just|another|perl|hacker/"
