Splunk Search

How can I determine if a field is an integer (whole number)

jedatt01
Builder

I want to use an if statement determine if a number is a integer or decimal. Is that possible? example

if(field1/field2 = "whole number","true","false")

0 Karma
1 Solution

woodcock
Esteemed Legend

jedatt01
Builder

Isint() works for what i need. Thanks

0 Karma

micahkemp
Champion

Perhaps a little modulus action:

if(field1%field2==0, "true", "false")
0 Karma
Get Updates on the Splunk Community!

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...