Wednesday, September 24, 2008

Regular expression for phone number formatting

SELECT REGEXP_REPLACE(
SUBSTR(
REGEXP_REPLACE (
'1-571 426-8102' -- sample phone number
,'[- ]' -- take out hyphen and spaces
),-10 -- read the last 10 numbers
)
,'([0-9]{3})([0-9]{3})([0-9]{4})'
,'\1-\2-\3' -- arrange in format xxx-xxx-xxxx
) phone
FROM dual;

No comments: