How to convert all non numeric values to blank in phone number field
I have an input phone number field that has some bad data in it. It includes some email addresses like Andrew@yahoo.com, special characters and an Extension value "x" for example "4034432253 x 311"
If I wanted to convert all non numeric data into blanks in this column how would I perform this along with removing the x in the extension
I know this string method replaces all characters that aren't numeric. Is there anyway that I can add on to this string method to convert any non numeric fields like email fields to blank if it contains @ sign.
