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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...