dimanche 24 juillet 2016

Phone number pattern to clean up

I have phone number field to clean up and trying to find the junk number which are in this format patterns of numbers: like 000000 ,111111,222222,3333333,4444444,.... Phone ---------------- (444)333-7777 555.666.6666 333.555-7777 222-222-2222 1111111111 5104554535 (555)(353)(5343) Phone(output i want to see is) 222-222-2222 1111111111 and second question i want to know the count of the records has special characters.from the above phone field i want to get 5 as count. Your help is appreciated.

Aucun commentaire:

Enregistrer un commentaire