isNumeric Search Operator
The
isNumeric
operator checks whether a string is a valid Java number. Valid numbers include hexadecimals marked with the 0x or 0X qualifier, octal numbers, scientific notation and numbers marked with a type qualifier, like 123L.
Syntax
isNumeric("<string>") as <field>
isNumeric(<string_field>) [as <field>]
Rules
true
if the string is a valid Java number.
false
.
09
will return false, since
9
is not a valid octal value. However, numbers beginning with
0
are treated as a decimal.
Examples
| isNumeric(num)