Re: Help: Blank spaces
From: Angelo Cavallaro <angelo.cavallaro_at_pcm.bosch.de>
Date: Wed, 03 Feb 1999 12:57:59 +0100
Message-ID: <36B839C7.719_at_pcm.bosch.de>
from dual;
Date: Wed, 03 Feb 1999 12:57:59 +0100
Message-ID: <36B839C7.719_at_pcm.bosch.de>
Sorry, this is better:
select
replace(
replace(
replace('This is a String',' ',chr(0)||chr(1))
,chr(1)||chr(0),'')
,chr(0)||chr(1),' ')
from dual;
Angelito.
Angelo Cavallaro wrote:
>
> Hi Jaime,
>
> in pure SQL u could use the following statement:
>
> select
> replace(
> translate(
> replace(
> replace('This is a String','
> ',chr(0)||chr(1))
> ,chr(1)||chr(0),chr(2))
> ,'x'||chr(2),'x')
> ,chr(0)||chr(1),' ')
> from dual;
>
> chr(0), chr(1) and chr(2) are not inputable (by the user) characters.
> 'x' is a dummy character, cause u need at least one substitution
> character in TRANSLATE, chr(2) is substituted by NULL.
>
> HTH
>
> Angelito.
Received on Wed Feb 03 1999 - 12:57:59 CET