Formatting phone numbers

angelards

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?

Sep 18 '08 #1

ck9663

Try:

-- CK

Sep 18 '08 #2