numerical value of text

  • Thread starter Thread starter Ken L
  • Start date Start date
K

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
 
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
Click to expand...

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:
 
Back
Top