Triple Quotes when saving to *.csv

[D]

When saving the file as *.csv, some text (brought up in notebook) has no
quotes around it (i.e. text) and text with quotes around it has triple quotes
around it (i.e. """text"""). Any help on how to save an excel file as a *.csv
and have all text have double quotes around it (i.e. "text"), when read in
notebook?

Thank you
--
D

[Bryan Hessey]

No idea, but, if it is of any help, the quotes are to protect commas in a csv (comma separated) format - so if you (in Excel) replace all , (comma) with .comma. and in your other application replace all .comma. with , you should be able to avoid all " (doublequote) characters.

When saving the file as *.csv, some text (brought up in notebook) has no
quotes around it (i.e. text) and text with quotes around it has triple quotes
around it (i.e. """text"""). Any help on how to save an excel file as a *.csv
and have all text have double quotes around it (i.e. "text"), when read in
notebook?

Thank you
--
D

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/textfiles.html

for one way.

In article <[email protected]>,
"D" <[email protected]> wrote:

> When saving the file as *.csv, some text (brought up in notebook) has no
> quotes around it (i.e. text) and text with quotes around it has triple quotes
> around it (i.e. """text"""). Any help on how to save an excel file as a *.csv
> and have all text have double quotes around it (i.e. "text"), when read in
> notebook?
>
> Thank you