Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 File Problems (Opening New Format) | Excel Discussion (Misc queries) | |||
Does a file know how long it was edited or changed (Excel) | Excel Discussion (Misc queries) | |||
Excel not detecting that a file is currently being edited | Excel Discussion (Misc queries) | |||
swf flash file embedded in html file which is edited in excel.. he | Excel Discussion (Misc queries) | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |