RE: Oracle REPLACE function and carriage returns

Thanks-
I realized that just a minute ago. It's been a long day!

Wendy Hopper

*248-696-6193 (Onstar) / 248-696-2390 (New King)
* wendy.hopper_at_eds.com

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Sent: Wednesday, March 19, 2003 4:58 PM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'wendy.hopper_at_eds.com'
Subject: RE: Oracle REPLACE function and carriage returns

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?
Received on Wed Mar 19 2003 - 16:05:23 CST