Thanks Razzak, I've got to find a way to re-insert the double quotes...
-Brad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Saturday, September 10, 2005 12:11 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Exporting to CSV & Quotes At 01:36 PM 9/10/2005, Brad Davidson wrote: >... when I GATEWAY EXPORT in CSV, then launch the file, >the double quotes shift to the next sentence. Brad, That is the result of double quote character in one of your column values. By design, the qualifier for column separator for CSV format is also double quotes. So, to avoid the shifting of column(s) when importing a CSV file into XLS, you may need to replace the double quotes in your column values to blank, prior to exporting the data as CSV. Example: -- start CONNECT ConComp UPDATE Customer SET Company = (SRPL(Company,'"','',0)) GATEWAY EXPORT CSV Customer.CSV + SELECT * FROM Customer + OPTION COL_NAMES ON + |QUALIFIER " + |SEPARATOR , + |BLANK_IF_ZERO OFF + |SHOW_PROGRESS ON + |MESSAGES ON + |ACTION OPENVIEW RETURN -- end You may try a different QUALIFIER for the CSV format, but that may lead to a different problem for XLS. Hope that helps! Very Best R:egards, Razzak.
