Re: Replacing Strings

On Sep 11, 1:41 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <e..._at_chicagorsvp.com> a écrit dans le message de news: adee164f-6729-416f-8eca-35556d30f..._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

But what about the leading spaces? Those disappear if I use replace or translate or even LPAD........ Received on Thu Sep 11 2008 - 14:01:25 CDT