View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default 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