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!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...