Splunk Search

How to use NOT in an IF condition?

prakashbhanu407
New Member

I have 2 files: Account and Account.TXT. I have to get only the "Account" file details. I tried:

if(  (like(filename,"Account%") AND NOT like(filename,"Account%.txt%")  ),filename,"X")

but it is returning both file types.

What is the mistake here?

0 Karma

woodcock
Esteemed Legend

Like this:

... | eval test = if((like(filename, "Account") AND NOT like(filename, "Account%.txt")), filename," X")

Your problem is the wildcard character %, most of which you do not need.

0 Karma

sundareshr
Legend

Why not just use .. | if(filename="Account", x, y) and skip the wildcard altogether?

prakashbhanu407
New Member

actually i have 2 sets of files X and Y,
X has about 10 different types of files including "AccountyyyyMMdd.hhmmss"(no extension)
Y has another 8 files types including "AccountyyyyMMdd.hhmmss.TXT"

So for the "X" type of files I have multiple "like()" functions in the if() condition, it should only retrieve data for "Account" file but it is also picking up for "Account.TXT" which should be of type "Y"
like below
if(
(like() like () ..... (like(filename,"Account%") AND NOT like(filename,"Account%.txt%")) ),"X" ,
if( (like() like()...like(filename,"Account%.txt%"),"Y","Other")
)
)

0 Karma

sundareshr
Legend

Try the match() with regex . Something like this should work

.... | eval x=case(match(filename, "Account\d+\.\d+$", "no extn", filename="\.(txt|TXT)$", "with extn", 1=1, "no match")
0 Karma
Get Updates on the Splunk Community!

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Announcing the General Availability of Splunk Enterprise Security 8.1!

We are pleased to announce the general availability of Splunk Enterprise Security 8.1. Splunk becomes the only ...

Developer Spotlight with William Searle

The Splunk Guy: A Developer’s Path from Web to Cloud William is a Splunk Professional Services Consultant with ...