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 | Why did the turkey cross the road?

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

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...