Suggestions to clean up phone numbers

Analytics
New Member

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

1 REPLY
Junior Supporter

Re: Suggestions to clean up phone numbers

Hi.

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

Cheers.

Carlos.