how to pass invalid characters as part of REGEX range?
549379Dec 5 2008 — edited Dec 8 2008Hello,
I am using the following query to fetch the email value(which contains invalid character) which successfully excluded the invalid character in any part of the email value.
SELECT REGEXP_REPLACE(EMAIL, '', '') from contact_table;
what i wanted to know is there any way to pass the range of invalid characters(which is not accpetable by XML parser) as part REGEX, so that sql result returned ALL the records excluded ALL the invalid characters?
pattern is like this : @"#x((10?|[2-F])FFF[EF]|FDD[0-9A-F]|7F|8[0-46-9A-F]9[0-9A-F]
Could you write the query which passes this kind of pattern as part REGEX?
Awaiting for the reply plz
thanks