replace CR LF in spaces or blanks

From: Bernhard Powolny <b.powolny_at_mobilkom.at>
Date: Tue, 31 Aug 1999 08:29:51 +0200
Message-ID: <7qfsp0$bib$1@fleetstreet.Austria.EU.net>

Hi everybody

May somebody can help me:

I have in a character field somewhere Carriage returns and Linefields Hex : 0D 0A );

If I spool this field out by SQL on unixplatform as a flat file i got somewehere carriage returns .

Exemple :

Field CHAR(150)

frisör Gabi
Labit

Hex interpetation :
47 61 62 0D 0A 4C 61 and so on

Q: How can i replace this characters into a blanks or other characters in SQL ?
(yes i can do on unix by perlprogramming too but this is not the Question)

The only anwser i got from oracle suport is to use the dump feature but there you only get the interpration from the characterfiel as for example Hec 0d 0a as 47,61,62,69,d,a,4c,61,62

Hope for an answer

b.powolny_at_mobilkom.at Received on Tue Aug 31 1999 - 01:29:51 CDT