All Forums Analytics
bassrick 1 post Joined 10/13
17 Oct 2013
Suggestions to clean up phone numbers

Hello,
I am receiving phone numbers from multiple tables.  No standardization was done on any of these tables for formatting.  I have values such as:
(888) 123-4567
(888)-123-4567
(888)  123-4567
888-123-4567
888 123-4567
8881234567
888.123.4567
 
I'm trying to find a way to basically peal off the numbers, such that I have 8881234567 and then reformat in this standard fashion: 888.123.4567
 
Thank you for you time!
Rick

CarlosAL 512 posts Joined 04/08
18 Oct 2013

Hi.
It seems oTranslate() + SUBSTR() could do the trick.
Cheers.
Carlos.

You must sign in to leave a comment.