try select translate(string,',"'''||chr(13),'XYZ ')
which should replace carriage return with a space. Iain Nicoll -----Original Message----- Sent: Wednesday, July 31, 2002 6:51 PM To: Multiple recipients of list ORACLE-L thanks for that everyone.... 1 more thing.. how can i get rid of Return characters? The problem i have.. i have a comments field on a form, i am exporting this(using text_io) into .csv, so where a user has pressed enter in the comments field, when moving that to csv it adds new line for every Return..cauising a big mess cheers --- "Ramasubramanian, Shankar (Cognizant)" <[EMAIL PROTECTED]> wrote: > Hi, > select translate(string,',"''','XYZ') from Dual > > Only for single quote you need the escape character > (another single > quote).The above query changes the comma character > to X , Double quote > character to Y and single quote character to Z. > > Regards, > Shankar > > This e-mail and any files transmitted with it are > for the sole use of the intended recipient(s) and > may contain confidential and privileged information. > If you are not the intended recipient, please > contact the sender by reply e-mail and destroy all > copies of the original message. > Any unauthorised review, use, disclosure, > dissemination, forwarding, printing or copying of > this email or any action taken in reliance on this > e-mail is strictly > prohibited and may be unlawful. > > Visit us at http://www.cognizant.com > __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
