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 ?
Solved! Go to 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
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.