Re: using wildcards with REPLACE
From: Knight <nospam_at_newsranger.com>
Date: Thu, 07 Jun 2001 15:30:00 GMT
Message-ID: <Y5NT6.2413$bA3.118532_at_www.newsranger.com>
Date: Thu, 07 Jun 2001 15:30:00 GMT
Message-ID: <Y5NT6.2413$bA3.118532_at_www.newsranger.com>
thnx for the tip - however the translate call won't work without a wildcard either if HTML formatting is to be removed.
There HAS to be a way, though.
Any more ideas?
In article <9fo20j$bkc10_at_kcweb01.netnews.att.com>, PT says...
>
>I don't think you can use wildcards with "REPLACE" , but this might help
>
>Try:
>select translate('abcd<123>ABCD','<>',' ') from dual;
>
>HTH
>PT
>
>"knight" <nospam_at_newsranger.com> wrote in message
>news:FbLT6.2221$bA3.107560_at_www.newsranger.com...
>> Hi,
>>
>> Can anyone tell me if wildcards are possible when using replace, eg:
>>
>> replace('mystring','<*>','')
>>
>> to remove all HTML formatting?
>>
>> Cheers,
>>
>> K
>>
>>
>
>
Received on Thu Jun 07 2001 - 17:30:00 CEST