Re: Regular expression help required please
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Tue, 21 Sep 2010 19:16:13 +0200
Message-ID: <4c98e85c$0$14246$ba620e4c_at_news.skynet.be>
Kevin S wrote:
> I think I have found an initial solution to my proposed solution.
>
> SELECT regexp_replace('H\el£lo World','[^[:alnum:][:space:]]', '')
> FROM dual;
>
> will strip out the alpha numerics while leaving white spaces.
>
> It's not ideal as it strips out £ signs and all punctuation, however
> it's characters that fall under the punctuation category (Bullet
> points, £ signs etc) which are causing the problem.
>
> Would anyone have any suggestions as to how to only strip out
> troublesome characters?
Date: Tue, 21 Sep 2010 19:16:13 +0200
Message-ID: <4c98e85c$0$14246$ba620e4c_at_news.skynet.be>
Kevin S wrote:
> I think I have found an initial solution to my proposed solution.
>
> SELECT regexp_replace('H\el£lo World','[^[:alnum:][:space:]]', '')
> FROM dual;
>
> will strip out the alpha numerics while leaving white spaces.
>
> It's not ideal as it strips out £ signs and all punctuation, however
> it's characters that fall under the punctuation category (Bullet
> points, £ signs etc) which are causing the problem.
>
> Would anyone have any suggestions as to how to only strip out
> troublesome characters?
Would this do?
select regexp_replace('H\eL€lo World', '[^[:print:]]','') from dual Received on Tue Sep 21 2010 - 12:16:13 CDT