Re: Replacing Strings
From: Álvaro G. Vicario <alvaroNOSPAMTHANKS_at_demogracia.com>
Date: Fri, 12 Sep 2008 12:02:02 +0200
Message-ID: <gademi$im$1@huron.algomas.org>
Date: Fri, 12 Sep 2008 12:02:02 +0200
Message-ID: <gademi$im$1@huron.algomas.org>
Michel Cadot escribió:
>> replace(column,'|',chr(10))
[...]
> 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.
If it works for you, it's possible that the O.P. is outputting the result into an HTML document where, as HTML dictates, leading spaces are ignored.
-- -- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programación web: http://bits.demogracia.com -- Mi web de humor al baño María: http://www.demogracia.com --Received on Fri Sep 12 2008 - 05:02:02 CDT