Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Filtering

Simon1187
9 - Comet

 

 

Hi there, @Qiu ,     

@atcodedog05 

 

I am trying to filter just numbers.  In my data set, there are numbers with strings. Could you please let me know how can I filter that? 

 

The sample data is below.

 

 

67487 817 975 is Dave (director), 166 is Lisa (Ops manager).

 

Simon1187_0-1636425768109.png

 

 

Thanks, 

 

 

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@Simon1187 
I suppose we can some Find and Replace.
Can you provide a bigger dataset?

Could not find where is the "67487 817 975 is Dave (director), 166 is Lisa (Ops manager)."?

Simon1187
9 - Comet

@Qiu 

Qiu
21 - Polaris
21 - Polaris

@Simon1187 

Hope this works for you.

1109-Simon1187.PNG

Simon1187
9 - Comet

Hi @Qiu , 

 

Thanks, if in the next step I want to filter string with a phone number from string. How can I achieve that?

Simon1187_0-1636437671441.png

 

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Simon1187,

 

You could use a similar approach to @Qiu but place wildcards at the start and end of the string so we're searching for where there are at least 6 characters from the set 0-9, space, ( and ).

 

REGEX_Match([Value], ".*[0-9\s+()]{6,}.*")

 

JonathanSherman_0-1636463600846.png

 

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

Labels
Top Solution Authors