Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: TRANSLATE
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)"
<RShankar1_at_CHN.COGNIZANT.COM> 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
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: imran9a_at_yahoo.com 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: ListGuru_at_fatcity.com (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).Received on Wed Jul 31 2002 - 12:50:32 CDT
![]() |
![]() |