Re: Replacing Strings

From: <sybrandb_at_hccnet.nl>
Date: Thu, 11 Sep 2008 22:42:37 +0200
Message-ID: <eh0jc4drnt8oogj260n7a0o12qpebki8i4@4ax.com>


On Thu, 11 Sep 2008 12:01:25 -0700 (PDT), exec_at_chicagorsvp.com wrote:

>On Sep 11, 1:41pm, "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........

I suggest you check (and post the results and your exact code) by prepending the string with an '*' or something like that. You must be doing something wrong: either your code is wrong, or you have a display problem.
Also you should also, in *every post* include your complete version number.
We can not be bothered to memorize it.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu Sep 11 2008 - 15:42:37 CDT

Original text of this message