Standardize Phone Numbera

KNIME Analytics Platform
1

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

703-321-8901

(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.

 

2

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