Check and Extract Phone Number from String

[tjamal1]

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 ?

[Jonathan-Sherman · Accepted solution]

Hi @tjamal1,

This could all be done inside one formula tool!

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]

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]

Hi @PATH 

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