Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
D
 
Posts: n/a
Default 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   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

  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem saving the file after moving worksheets into another SteveD62226 Excel Discussion (Misc queries) 0 November 18th 05 11:01 PM
Triple occurence formula toyota58 Excel Worksheet Functions 1 August 19th 05 10:43 AM
How do I stop Excel 2000 from saving file history from file that . Cathy Excel Discussion (Misc queries) 0 March 29th 05 03:27 PM
why are there quotes in my exported text file? Gordon Excel Discussion (Misc queries) 2 February 16th 05 07:59 PM
saving excel file as tab delimited Craig Hilliard Excel Discussion (Misc queries) 0 February 1st 05 11:39 PM


All times are GMT +1. The time now is 04:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"