Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle REPLACE function and carriage returns

RE: Oracle REPLACE function and carriage returns

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Wed, 19 Mar 2003 15:57:56 -0600
Message-Id: <24715.322446@fatcity.com>


Yes. CHR(10) is linefeed ("LF"). CHR(13) is carriage return ("CR", aka "^M").

Enjoy! :)

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA


-----Original Message-----
From: Hopper, Wendy S [mailto:wendy.hopper_at_eds.com] Sent: Wednesday, March 19, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L Subject: Oracle REPLACE function and carriage returns

Hi all-

I am trying to write a query that strips carriage returns from a comment field while selecting the data to a file. I have used the following command -

select replace( field1, chr(10), '*' ) from table1;

The query seems to remove the carriage returns when returning the data via sqlplus, but when I spool the output to a file it still shows ^m followed by * in it. Any ideas on what is going on here?

Thanks for any help. Received on Wed Mar 19 2003 - 15:57:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US