We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

REGEX Question

Ahhvivian
5 - Atom

I am having issues with filtering my data to get unique job codes that have at least two alpha letters anywhere in the job code. This is what I have so far, but it's only filtering two letters that are next to each other

 

Screenshot 2025-04-16 220821.png

5 REPLIES 5
flying008
15 - Aurora

Hi, @Ahhvivian 

 

What are you want output ? please upload the result as your mind.

OTrieger
14 - Magnetar

@Ahhvivian 

You can use Cleanse Tool to do the work, Remove everything except letters using Cleanse Tool and you will end  up with the letters only, then check the length and you will get the solution for your problem, now you can filter all the entries that are not falling under your criteria.

Qiu
21 - Polaris
21 - Polaris

@Ahhvivian 
Maybe you can try like this?

0417-Ahhvivian.png

Ahhvivian
5 - Atom

Hello,

 

This is what I have to find:

 

Screenshot 2025-04-17 144456.png

 

caltang
17 - Castor
17 - Castor

Are you solving your homework via community solutioning on your behalf? 

 

Next time, export your workflow rather than giving us a .yxmd, can't see the data.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors