Replacing Strings
From: <exec_at_chicagorsvp.com>
Date: Thu, 11 Sep 2008 10:17:19 -0700 (PDT)
Message-ID: <adee164f-6729-416f-8eca-35556d30f7a2@m45g2000hsb.googlegroups.com>
Date: Thu, 11 Sep 2008 10:17:19 -0700 (PDT)
Message-ID: <adee164f-6729-416f-8eca-35556d30f7a2@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? Received on Thu Sep 11 2008 - 12:17:19 CDT