RE: TRANSLATE

From: Imran Ashraf <imran9a_at_yahoo.com>
Date: Wed, 31 Jul 2002 09:50:32 -0800
Message-ID: <F001.004A7A68.20020731095032@fatcity.com>

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
>

---

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: 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