Oracle-L: Re: replace lines feeds in a string

From: Alan Davey <adavey_at_competitrack.com>
Date: Mon, 18 Nov 2002 05:54:53 -0800
Message-ID: <F001.0050582B.20021118055453@fatcity.com>

Hi,

Why not just use the replace function?

select replace('Line1'||chr(10)||'Line2',chr(10),' ') from dual

select replace(my_string,chr(13)||chr(10),' ') from my_table;

HTH,

-- 

Alan Davey
adavey_at_competitrack.com
212-604-0200  x106


On 11/18/2002 7:18 AM, John Dunn <john.dunn_at_sefas.co.uk> wrote:


>I want to replace any carriage returns and lines feeds 'OD0A' and 

>'0A' in

>string, with a  space. Can this be done with TRANSLATE, if so how 

>do I code

>this?

>

>John Dunn

>Sefas Innovation Ltd

>0117 9154267

>www.sefas.com

>

>-- 

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>-- 

>Author: John Dunn

>  INET: john.dunn_at_sefas.co.uk

>

>Fat City Network Services    -- 858-538-5051 http://www.fatcity.com

>San Diego, California        -- Mailing list and web hosting services

>---------------------------------------------------------------------

>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: Alan Davey
  INET: adavey_at_competitrack.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Mon Nov 18 2002 - 07:54:53 CST