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?

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