Help cleaning up phone number to extract area codes

[aven]

A newbie to Alteryx here!

Looking for a way to clean up phone numbers and then extract the 3-digit area codes excluding any character, spaces and country code starting with 1

Ex: (342) 456- 6789  to get 342

16043308811 to get 604

Thanks in advance!

Aven

[fmvizcaino]

Hi @aven ,

Attached is a solution showing how to parse your code with the parse method from regex tool.

Best,

Fernando Vizcaino

[AbhilashR · Accepted solution]

Hi @aven, you could retrieve the area codes using Formula tool or Regex tool, whichever you are comfortable with. Attached solution is an implementation using the Formula tool approach. 

Hope this helps!

[aven]

This worked perfectly. Thanks a million @AbhilashR 

[aven]

Thank you @fmvizcaino. For some reason, a few of the records from the output was extracting numbers middle of the 10 digit phone field.