Splunk Search

NOT Like function

athorat
Communicator

I am using this like function in in a pie chart and want to exclude the other values
How do I use NOT Like or id!="%IIT" AND id!="%IIM"

|eval id = case(like(id, "%PAS"),"PAS",like(id, "%SIS"),"SIS",like(id, "%HDES"),"HDES",1=1,id)

Tags (2)

ChrisFontana
Loves-to-Learn Lots

Hey, just use like you wrote before, NOT LIKE. E.g.:

| where NOT LIKE("FIELD_NAME","%TEXT%")

0 Karma

woodcock
Esteemed Legend

You can do this:

Your Search Here | regex fieldName != "RegExHere"

cnoerjadi
Engager

try this

| where !LIKE(foo, "$abc")

raghu0463
Explorer

how to filter for multiple values please i.e

|where !LIKE(foo, "$abc", "xxx", "sss")

0 Karma

nick405060
Motivator

Can someone convert this to the answer?

0 Karma

renjith_nair
Legend

@nick405060 , converted the comment to answer so that it could be accepted as answer.

---
What goes around comes around. If it helps, hit it with Karma 🙂
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 ...