Splunk Search

How to use If and Not statement in one pass?

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

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

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

Path Finder

That worked, thanks!

0 Karma