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
Solved! Go to Solution.
Hi @aven ,
Attached is a solution showing how to parse your code with the parse method from regex tool.
Best,
Fernando Vizcaino
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!
This worked perfectly. Thanks a million @AbhilashR
Thank you @fmvizcaino. For some reason, a few of the records from the output was extracting numbers middle of the 10 digit phone field.