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

Filter with Regex for Specific word + character + digit

Doc-blue
5 - Atom

Hi All, 

I struggle to find a way to filter for a specific list of Word followed by a "-" and digit.

Example
BRE-5555
ATT-8888
CCC-123
BRE-123 / 456
BRE-1234 / 456
ATT 789

The goal, is to filter out the cell that have the format expect (only the words BRE or ATT followed by a "-" followed with 3 or 4 digit. Anything that doesn't follow this rules is filtered out. So, only BRE-XXXX or BRE-XXX or ATT-XXXX or ATT-XXX

Meaning in the example above, only these one are right: 

BRE-5555
ATT-8888


Everything will be considered as wrong, I am able to filter per word with a simple filter tool, or the digits with regex, but not to make the full rule in one filter with Regex. I can have to different filter, one for BRE one for ATT, but I am unable to make the filtering working for the full word + "-" + 3 or 4 digits

2 REPLIES 2
binu_acs
21 - Polaris

@Doc-blue one way of doing this

image.png

Doc-blue
5 - Atom

Thank you @binuacs! It worked perfectly! It helped me also to understand what I was doing wrong! 

Labels
Top Solution Authors