numerical value of text

[Ken L]

I have a text field with entries consisting of numerals or
text, which are verbatim entries from paper forms. Eg.
some records are "80", "162" etc. and some
are "normal", "none" etc. I am trying to find an
expression that allows me to search for numerical values >
100 in all these text entries. This was the NUM()
function back in good old BASIC. Is there any equivalent
here?

Thanks,

Ken

 

[fredg]

I have a text field with entries consisting of numerals or
text, which are verbatim entries from paper forms. Eg.
some records are "80", "162" etc. and some
are "normal", "none" etc. I am trying to find an
expression that allows me to search for numerical values >
100 in all these text entries. This was the NUM()
function back in good old BASIC. Is there any equivalent
here?

Thanks,

Ken

You can use
Exp:Val([TextField])
Text such as Normal, none, etc. will return a 0 value
123 will return 123 (as a number)
As criteria for this field, write: