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?

exec (AT) chicagorsvp (DOT) com wa:
It's hard to tell from what you describe, but is this your desired
result?
AA
BB
CC
DD


Just curious, are trying to view the result of this in the iSQL*Plus
web interface? (multiple spaces are ignored in HTML rendering)

--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

exec (AT) chicagorsvp (DOT) com wa:
It's hard to tell from what you describe, but is this your desired
result?
AA
BB
CC
DD


Just curious, are trying to view the result of this in the iSQL*Plus
web interface? (multiple spaces are ignored in HTML rendering)

--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

exec (AT) chicagorsvp (DOT) com wa:
It's hard to tell from what you describe, but is this your desired
result?
AA
BB
CC
DD


Just curious, are trying to view the result of this in the iSQL*Plus
web interface? (multiple spaces are ignored in HTML rendering)

--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator

exec (AT) chicagorsvp (DOT) com wa:
It's hard to tell from what you describe, but is this your desired
result?
AA
BB
CC
DD


Just curious, are trying to view the result of this in the iSQL*Plus
web interface? (multiple spaces are ignored in HTML rendering)

--
"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator