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