Question on the "csv" library
David Smith
dns4 at cornell.edu
Fri Aug 28 13:06:09 EDT 2009
vsoler wrote:
>
> 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
> differently
True, but there are commonalities. See
http://en.wikipedia.org/wiki/Comma-separated_values
>
> 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.
--David
More information about the Python-list
mailing list