Filtering string text in phone numbers

[Simon1187]

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 · Accepted solution]

@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")

[Simon1187 · Accepted solution]

Hi @hellyars, 

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

Thanks, 

Simon