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.
SOLVED

Filter based off number vs text

navypoint16
8 - Asteroid

I'm trying to filter my data based on the first character of the cell, whether it's a letter or a number.  The only differentiating factor is the first character, so I was thinking something along the lines of a LEFT((isDigit),1), but I don't think that's the right way to do it.

2 REPLIES 2
JoBen
11 - Bolide

Hi @navypoint16, if your filter field is a string, the Left([Field],1)="...", formula should work. 

jdunkerley79
ACE Emeritus
ACE Emeritus

You can do a REGEX_Match:

 

REGEX_Match([Field1],"^\d.*")

Which will return True (starts with a digit) or False (doesn't)

 

An alternate way would be ASCII code:

CharToInt([Field1]) >= 48
AND
CharToInt([Field1]) <= 57
Labels
Top Solution Authors