Filter based off number vs text

[navypoint16]

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.

[JoBen]

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

[jdunkerley79 · Accepted solution]

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