I have a phone Field where records vary with how they were entered with punctuations: examples:
2485551212
248.555.1212
248-555-1212
248 555 1212
along with a few others. I am looking for a script to write them all to the same format. preferable 248-555-1212 or no punctuation at all.
I'm not sure if I should do a replace script to remove the unwanted characters or if there is something that will delete all non numeric characters from the field and then do an input mask?