Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem saving the file after moving worksheets into another | Excel Discussion (Misc queries) | |||
Triple occurence formula | Excel Worksheet Functions | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
why are there quotes in my exported text file? | Excel Discussion (Misc queries) | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) |