Re: Replacing Strings

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 11 Sep 2008 20:41:21 +0200
Message-ID: <48c96654$0$22020$426a74cc@news.free.fr>

<exec_at_chicagorsvp.com> a écrit dans le message de news: adee164f-6729-416f-8eca-35556d30f7a2_at_m45g2000hsb.googlegroups.com...
| Hi,
|
| We have some messages stored in a column in this format: AA|BB|CC|DD
|
| What we want is to replace the vertical bars with a CHR(10) for line
| feed, but have 3 leading spaces.
|
| Everything I try seems to only indent the first item 3 characters.
| Even I try to replace it with ' ' || CHR(10) and it ignores the
| spaces.......
|
| What we want is:
| AA
| BB
| CC
|
| Ideas anyone?

replace(column,'|',chr(10))

Regards
Michel Received on Thu Sep 11 2008 - 13:41:21 CDT

Original text of this message