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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...