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
isNumeric("<string>") as <field>
isNumeric(<string_field>) [as <field>]
trueif the string is a valid Java number.
- Null and empty/blank strings will return
- Non-hexadecimal strings beginning with a leading zero are treated as octal values. Thus the string
09will return false, since
9is not a valid octal value. However, numbers beginning with
0are treated as a decimal.
| isNumeric("1.56") as isNum Returns
| isNumeric("1e5") as isNum Returns