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.
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire