Skip to main content

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

  • Returns true if the string is a valid Java number.
  • Null and empty/blank strings will return false.
  • Non-hexadecimal strings beginning with a leading zero are treated as octal values. Thus the string 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)

The following returns true:

| isNumeric("1.56") as isNum

The following returns true:

| isNumeric("1e5") as isNum
Status
Legal
Privacy Statement
Terms of Use

Copyright © 2024 by Sumo Logic, Inc.