Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Check and Extract Phone Number from String

tjamal1
8 - Asteroid

Hello, 

I have a column which contains string like 

 

Phone: (607) 530-7670 ABC , Zios

 

I want to first check whether this string contains (607) 530-7670 this pattern and create another column (TRUE,FALSE)

Then once its true create another column which extract this contact number from above mentioned string

 

How can i do this in Alteryx ?

3 REPLIES 3
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @tjamal1,

 

This could all be done inside one formula tool!

 

image.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

PATH
5 - Atom

Phone Number Extract Item.JPG

Can you use that formula in this situation? There is no rhyme or reason to where a number might be, but it always has the XXX-XXX-XXXX format. 

atcodedog05
22 - Nova
22 - Nova

Hi @PATH 

 

Can you post it as a new question and provide some sample data. We will be happy to help 🙂

Labels