ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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