Buddy,
Thanks for the tip, but I've got to come up with a way to retain the quotation marks. -Brad -----Original Message----- From: Walker Buddy [mailto:[EMAIL PROTECTED] On Behalf Of Walker Buddy Sent: Saturday, September 10, 2005 11:55 AM To: RBG7-L Mailing List Subject: RE: [RBG7-L] - Exporting to CSV & Quotes 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 `
<<attachment: winmail.dat>>
