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