Re: Replacing Strings

<exec_at_chicagorsvp.com> a écrit dans le message de news: d5102e08-47e1-433b-b144-913764321d16_at_e53g2000hsa.googlegroups.com... 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........

It is not my experience.
Copy and paste what you did.

Regards
Michel Received on Thu Sep 11 2008 - 14:49:37 CDT