Triple Quotes when saving to *.csv
 

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

Triple Quotes when saving to *.csv
 

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.


D 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
--
D


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=490510

Triple Quotes when saving to *.csv
 

See

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

for one way.

In article ,
"D" 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