Brad If you can do without the double quotes why not remove them in your temporary table by using the SRPL function before exporting the data. UPDATE temporaryTable SET tempColName = (SRPL(TempColName,'"','',0)) Buddy
________________________________ From: [email protected] on behalf of Brad Davidson Sent: Sat 9/10/2005 1:36 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Exporting to CSV & Quotes I've concatenated 2 note fields into one column of a temporary table. One of the note fields has double quotes around a section of text. Viewing the results of the concatenated data in the temporary table is fine. However, when I GATEWAY EXPORT in CSV, then launch the file, the double quotes shift to the next sentence. End user of this data requires CSV format, without massaging data or format in Excel - any ideas what I can do to resolve this? Much appreciated! -Brad Davidson CHAR VALUES: BLANK DELIMIT , LINEEND รพ SEMI ; QUOTES ' PLUS + SINGLE _ MANY % IDQUOTES `
<<winmail.dat>>
