Splunk Search

how to exclude some values from results returned by makemv

nickrallysplunk
New Member

My data has a field FooBar, and

| stats count by FooBar

returns:

FooBar        count
-------------------
foo,bar,baz          
foo,baz          
bar,x_waldo 

To split FooBar into individual values I use makemv:

| makemv delim="," FooBar | stats count by  FooBar

and it now returns this table as expected:

FooBar        count
-------------------
foo              
bar              
baz
x_waldo

So far so good.

How can I exclude any values that start with "x_", as in "x_waldo" ?
I tried a simpler task to remove "x_waldo" (instead of excluding all values that start with "x_" pattern) using mvfilter but it did not work. Thank you!

Tags (1)
0 Karma
1 Solution

mhpark
Path Finder

Can't you just add a

| search FooBar!=x_*

at the end of the query?

View solution in original post

0 Karma

mhpark
Path Finder

Can't you just add a

| search FooBar!=x_*

at the end of the query?

0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...