Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Regular Expression confusion
It doesn't seem to like replacing '-' along with anything else, as a workar=
ound you could do this;
GSDBP2> l
1 select regexp_replace(UPPER(regexp_replace('A-JBurk','[''''|"|;| |-|,|=
.]')),'-')
2* from dual
GSDBP2> /
REGEXP
Ian
This email is only intended for the person to whom it is addressed and may = contain confidential information. If you have received this email in error,= please notify the sender and delete this email which must not be copied, d=istributed or disclosed to any other person.
Unless stated otherwise, the contents of this email are personal to the wri= ter and do not represent the official view of Ordnance Survey. Nor can any = contract be formed on Ordnance Survey's behalf via email. We reserve the ri=ght to monitor emails and attachments without prior notice.
Thank you for your cooperation.
Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 21 2005 - 09:29:59 CDT