Standardize Phone Numbera

I hate to start a common project from scratch when I know many people before me have handled the same problem before and would probably share a solution.

I have a user entered phone numberr column (string).  Naturally every user entered there own format like:



(703) 321.8901  etc, etc

Is there an example workflow to standardize the formats of a string phone number.  I'm particularly intererdted in extracting the area code portion for use in frequency distrubution analysis.


Maybe perform a search for regex phone numbers on or on google ? KNIME's String Manipulation node allows you to apply Regex.