LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Format of CSV file not preserved when edited in Excel 2007

Here's my problem. I get a CSV file from a vendor that I need to edit. The
file comes in the following format:
"field1","field2","field3","field4"

After editing the file and saving as a CSV, my data looks like the following
in a text editor:
field1,field2,field3,field4

In order to send the file back to the vendor I need those quotation marks
back. I've tried importing the data and setting the text qualifier to {none},
which accomplishes the goal of preserving the quotation marks, however when I
save as a CSV file, my data comes out as so:
"""field1""","""field2""","""field3""","""field4"" "

Any input would be greatly appreciated.
 
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
Excel 2007 File Problems (Opening New Format) Grazen Excel Discussion (Misc queries) 2 July 21st 06 04:24 PM
Does a file know how long it was edited or changed (Excel) Lauralalulu Excel Discussion (Misc queries) 1 March 3rd 06 07:05 PM
Excel not detecting that a file is currently being edited cds_tech Excel Discussion (Misc queries) 1 June 27th 05 09:06 PM
swf flash file embedded in html file which is edited in excel.. he I Believe Excel Discussion (Misc queries) 0 June 16th 05 10:06 PM
Formula Integrity Not Preserved During Sort in Excel 2000 Kevin Excel Discussion (Misc queries) 1 April 15th 05 10:26 PM


All times are GMT +1. The time now is 08:52 PM.

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

About Us

"It's about Microsoft Excel"