Re: How to convert carriage return character to space?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 22 Dec 1999 10:45:52 +0100
Message-ID: <83q6kg$54p$1@news3.isdnet.net>

You can use translate function:

v734> create table t (col varchar2(10)); v734> insert into t values ('my
  2 cr');
v734> select * from t;

COL

---

my
cr

1 row selected.

v734> select dump(col) from t;

DUMP(COL)

---

Typ=1 Len=5: 109,121,10,99,114

1 row selected.

We see that carriage return is character 10, so:

v734> select translate(col,chr(10),'@') from t;

TRANSLATE(

---

my_at_cr

1 row selected.

--
Have a nice day
Michel

<veronicahlee_at_my-deja.com> a écrit dans le message : 83pmo9$v88$1_at_nnrp1.deja.com...
> Hello,
>
> I am encountering problems with carriage return character (displayed in
> Oracle as thick vertical bar) in the data.
> If anyone knows how to convert it to space, I'd appreciate it.
>
> Veronica
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 22 1999 - 03:45:52 CST