Triple Quotes when saving to *.csv

[Guest]

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

 

[Bryan Hessey]

No idea, but, if it is of any help, the quotes are to protect commas i
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.

 

[JE McGimpsey]

See

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

for one way.