In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How do I filter out a column's item that start with alphabet letter?

ryanzhang487
8 - Asteroid

Hi community, I have a column example as follows:

I would like to filter out any items that is starting with alphabet letter,

What will be the formula?

Thank you

 

Order number
1001-521
1001-523
5646-654
AAAA
S WEE RE
Z-FGG
3 REPLIES 3
SPetrie
13 - Pulsar

A filter tool using REGEX_Match([Order Number],"\d.*") 

rzdodson
12 - Quasar

@Assuming the records you want always have a four digit prefix, followed by a hyphen, then followed by three digits, you can use Regex_Match in a filter tool to get the records you want.

 

Fitler Data with Alphabet letters.png

caltang
17 - Castor
17 - Castor

@ryanzhang487 

You can also try this:

image.png

 

REGEX_Match([Order number], "^[A-Za-z].*")

 

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