Replacing Characters
From: <exec_at_chicagorsvp.com>
Date: Thu, 11 Sep 2008 10:06:50 -0700 (PDT)
Message-ID: <0d76fe93-3cad-4d74-ab5c-b3c8112c9760@d1g2000hsg.googlegroups.com>
Date: Thu, 11 Sep 2008 10:06:50 -0700 (PDT)
Message-ID: <0d76fe93-3cad-4d74-ab5c-b3c8112c9760@d1g2000hsg.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.......
Ideas anyone? Received on Thu Sep 11 2008 - 12:06:50 CDT