Skip to main content

isNaN and isInfinity Function

The isNaN and isInfinity operators check a numeric string and return a boolean value.

  • isNaN returns true if the string value is not a number, false otherwise.
  • isInfinity returns true if the string value is a positive or negative infinity, false otherwise.
note

Null, empty, or blank strings will not return a result.

Syntax

isNaN("<string>") as <field>
isNaN(<string_field>) [as <field>]
isInfinity("<string>") as <field>
isInfinity(<string_field>) [as <field>]

Examples

| 5/0 as infinity
| isInfinity(infinity) as boolean

Returns boolean as true.  

| parse "has * total tokens" as total_token
| where !isNaN(total_token)

Returns results where total_token values are a number.

Legal
Privacy Statement
Terms of Use

Copyright © 2023 by Sumo Logic, Inc.