ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Filtering string text in phone numbers

Simon1187
8 - Asteroid

Hi everyone, 

 

I hope you are well and safe! 

 

I would like to filter a column and find out phone numbers that contain string. Could you please help me with that. 

 

I have attached the excel file. 

 

Thanks, 

Simon 

hellyars
12 - Quasar

@Simon1187 

 

Try this in a formula tool.  Then filter.  Is this what you meant?

 

Note:  It ignores the + symbol and any () embedded in a phone number (so long as there is no space \s),

 

 

 

iif(REGEX_Match([Phone Number],"(.*)?\s\D(.*)?"),"False","True")

 

 

 

Screen Shot 2021-05-04 at 9.23.57 PM.png

Simon1187
8 - Asteroid

Hi @hellyars

 

Thank very much. Yes that's what I want.

 

Thanks, 

Simon

Labels