I currently have a database with a field phone numbers however there are roughly 10000 records and 45-50 different entry styles.

I have now set up an input mask however I amk wondering how I could automate a clean up of them into the standard !(###) ###-####