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

Builder

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

0 Karma
1 Solution

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

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

Builder

thanks. its worked 🙂

0 Karma

Esteemed Legend

I would use null() instead of "".

0 Karma