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!

Build Your First SPL2 App!

Watch the recording now!.Do you want to SPL™, too? SPL2, Splunk's next-generation data search and preparation ...

Exporting Splunk Apps

Join us on Monday, October 21 at 11 am PT | 2 pm ET!With the app export functionality, app developers and ...

[Coming Soon] Splunk Observability Cloud - Enhanced navigation with a modern look and ...

We are excited to introduce our enhanced UI that brings together AppDynamics and Splunk Observability. This is ...