topic Re: How can I determine if a field is an integer (whole number) in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325294#M96997 <P>Perhaps a little modulus action:</P> <PRE><CODE>if(field1%field2==0, "true", "false") </CODE></PRE> Thu, 01 Jun 2017 20:39:42 GMT micahkemp 2017-06-01T20:39:42Z How can I determine if a field is an integer (whole number) https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325293#M96996 <P>I want to use an if statement determine if a number is a integer or decimal. Is that possible? example</P> <P>if(field1/field2 = "whole number","true","false")</P> Thu, 01 Jun 2017 20:35:15 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325293#M96996 jedatt01 2017-06-01T20:35:15Z Re: How can I determine if a field is an integer (whole number) https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325294#M96997 <P>Perhaps a little modulus action:</P> <PRE><CODE>if(field1%field2==0, "true", "false") </CODE></PRE> Thu, 01 Jun 2017 20:39:42 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325294#M96997 micahkemp 2017-06-01T20:39:42Z Re: How can I determine if a field is an integer (whole number) https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325295#M96998 <P>Splunk has both <CODE>isint</CODE> and <CODE>isnum</CODE> functions:</P> <P><A href="http://docs.splunk.com/Documentation/Splunk/6.6.1/SearchReference/InformationalFunctions">http://docs.splunk.com/Documentation/Splunk/6.6.1/SearchReference/InformationalFunctions</A></P> Thu, 01 Jun 2017 20:44:16 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325295#M96998 woodcock 2017-06-01T20:44:16Z Re: How can I determine if a field is an integer (whole number) https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325296#M96999 <P>Isint() works for what i need. Thanks</P> Fri, 02 Jun 2017 01:30:13 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-determine-if-a-field-is-an-integer-whole-number/m-p/325296#M96999 jedatt01 2017-06-02T01:30:13Z