Getting Data In

i have column a,b,c and i want to delete only in b column where value is 2. remaining columns should have to be same. i tried with mvfilter but it makes empty all the columns. i want to delete/remove particular value and make the field empty

DataOrg
Builder

a b c
1 2 3
2 1 4
4 1 2
1 2 3

0 Karma
1 Solution

dineshraj9
Builder

Just replace the value in column b when value is 2 with empty string -

<your search>  | eval b=if(b=2,"",b)

View solution in original post

dineshraj9
Builder

Just replace the value in column b when value is 2 with empty string -

<your search>  | eval b=if(b=2,"",b)

DataOrg
Builder

thanks. its worked 🙂

0 Karma

woodcock
Esteemed Legend

I would use null() instead of "".

0 Karma
Get Updates on the Splunk Community!

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...