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

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!

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...

Reminder! Splunk Love Promo: $25 Visa Gift Card for Your Honest SOAR Review With ...

We recently launched our first Splunk Love Special, and it's gone phenomenally well, so we're doing it again, ...