Data Clean-Up

[darall]

I have table that has messy phone number data, the structure of the numbers vary so I need to strip out all of the extra characters; spaces, periods, dashes, asterisks, commas, parentheses and slashes.

For example in one record the phone number is (###)###-####, in the next it is ###-###-#### or ###/###-####.

This is an import that we have to do frequently so right now I am just doing a find replace to remove these characters. But I would love to automate this.

Does anyone know of a way to automate stripping out these extra characters?

 

[PHV]

Take a look at the Replace function (if ac 2k or above)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244