Splunk Search

Passing comparison operators in a variable

ohbuckeyeio
Communicator

Is there a way to dynamically pass a comparison operator as a variable without a macro? I am looking to achieve something similar to what is shown below.

| eval number=8
| eval operator=">="
| eval comparison=7
| eval validate=if(number.operator.comparison,"yep","nope")
0 Karma
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

Considering there only are six common comparison operators = != < <= > >= I'd recommend creating a macro that houses a big case statement.

View solution in original post

martin_mueller
SplunkTrust
SplunkTrust

Considering there only are six common comparison operators = != < <= > >= I'd recommend creating a macro that houses a big case statement.

ohbuckeyeio
Communicator

Thank you Martin. I was assuming this would be the answer but was hoping for something more concise. I appreciate the help.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

There are only ugly options, e.g. iterating through all operators with case(), or map. What are you trying to achieve?

0 Karma

ohbuckeyeio
Communicator

Hi Martin. I have a kvstore with rows that have a numerical field and an operator field (among others). I would like to loop through those rows and build a dynamic comparison based off of some search results.

In the example above, the field "number" is from an indexed search. The operator and comparison fields are in the kvstore. I would like to be able to dynamically compare the number/comparison fields based on the provided operator value.

The operators could be any standard operator (=,!=,>=, etc...)

0 Karma
Get Updates on the Splunk Community!

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...

From Alert to Resolution: How Splunk Observability Helps SREs Navigate Critical ...

It's 3:17 AM, and your phone buzzes with an urgent alert. Wire transfer processing times have spiked, and ...