Question on the "csv" library
dns4 at cornell.edu
Fri Aug 28 19:06:09 CEST 2009
> Thank you very much for all your comments. After reading them I can
> conclude that:
> 1- the CSV format is not standardized; each piece of software uses it
True, but there are commonalities. See
> 2- the "C" in "CSV" does not mean "comma" for Microsoft Excel; the ";"
> comes from my regional Spanish settings
The C really does stand for comma. I've never seen MS spit out
semi-colon separated text on a CSV format.
> 3- Excel does not even put quotes around litteral texts, not even when
> the text contains a blank
There is no need to quote text literals with whitespace in them. There
is a need when a newline exists or when the separator character is
embedded in the field.
More information about the Python-list