1 of 1 people found this helpful
If all numeric, then it will return a value. If not all numeric, it will return null.
You can embed that, something like this:
SUM( IF NOT ISNULL(INT([string])) then 1 else 0 END )
That sum will give you the number of entries that are numeric.
By golly, Joe!
You dun did it again! Brilliant. My mind doesn't even work like that.
I Just had to comment on it.
This worked great!
I found another way, though it's a bit more complicated. I used the RAWSQL_BOOL() function (first time I've given that a try), and it looked like this:
RAWSQL_BOOL("ISNUMERIC (%!) <> 0",[string])
This brought back the value "True" for every field row that was indeed numeric. Fun exercise, and it's always refreshing to get a new function to work for the first time!
Here you go!
LEN(REGEXP_REPLACE([Seat From Num],'^[0-9]*$',''))=0
null = null
False = Alphanumeric
True = Numeric
Works by removing all numbers to see if you end up with nothing left