RE: TRANSLATE

From: Nicoll, Iain (Calanais) <iain.nicoll_at_calanais.com>
Date: Wed, 31 Jul 2002 10:17:48 -0800
Message-ID: <F001.004A7BAE.20020731101748@fatcity.com>

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)" <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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicoll, Iain (Calanais)
  INET: iain.nicoll_at_calanais.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 - 13:17:48 CDT