Splunk Search

How to use If and Not statement in one pass?

splunker1981
Path Finder

Hello all,

What's the best way to use a NOT statement in an if statement. I'm trying to accomplish something similar to the below.

| eval x_height=if(isnull(x_height) AND NOT (sourcetype=mysourcetypeHere),"Not Defined",x_height)
Tags (2)
0 Karma
1 Solution

woodcock
Esteemed Legend

This is more clear:

| eval x_height=if((sourcetype=="mysourcetypeHere"), null(), coalesce(x_height, "Not Defined")) 

View solution in original post

0 Karma

woodcock
Esteemed Legend

This is more clear:

| eval x_height=if((sourcetype=="mysourcetypeHere"), null(), coalesce(x_height, "Not Defined")) 

View solution in original post

0 Karma

splunker1981
Path Finder

That worked, thanks!

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!