First Cut at CSV PEP

Skip Montanaro skip at pobox.com
Wed Jan 29 00:09:58 CET 2003


    Cliff> Don't save as CSV, save as TSV, which is the same, but with tabs
    Cliff> rather than commas.  I don't know that it allows specifying the
    Cliff> quote character.

Looking at the choices more closely, I see Excel has multiple tabular save
formats.  I just saved a simple sheet in each of the formats and scp'd it to
my laptop.  I'll check 'em out later.

    Cliff> IIRC, you can embed a newline in a cell by entering " in a cell
    Cliff> to mark it as a string value, then I think you can then just hit
    Cliff> enter (or perhaps ctrl+enter).

That didn't work, but I eventually figured out that ALT+ENTER allows you to
enter a "hard carriage return".

Skip



More information about the Csv mailing list