removing carriage returns

[RycherX]

Can I through a select statement takeout all the carriage returns within a field when I retrieve it?

 

[SantaMufasa]

Rycher,

I'll bet we can, but we need an example of your INPUT and the OUTPUT you hope to see. Could you please post a sample or two?

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:26 (24Aug04) UTC (aka "GMT" and "Zulu"), 11:26 (24Aug04) Mountain Time)

 

[lewisp]

Hope I'm not treading on your toes here, Santa.

The carriage return character in Oracle is Chr(10), so you could replace all CRs with spaces:

[tt]SELECT Replace(<your_string>,Chr(10),' ')
FROM <your_table>[/tt]

 

[sem]

Actually carriage return (CR) is CHR(13). CHR(10) is line feed (LF). In Windows a combination CHR(13)||CHR(10) is used as line separator, in Unix - only CHR(10).

Regards, Dima

http://seminihin.narod.ru