topic Re: How to change a specific value of a field in my events to another value in a search? in Splunk Search

How to change a specific value of a field in my events to another value in a search?

fdi01 — Fri, 17 Apr 2015 15:43:25 GMT

i have these events:

status         |    host     |         comments          |   ticket_number  ...
inprogress         fdi_pc        tiket edited(17-04-15)           08
closed             hp_pc         tiket edited(17-04-15)           123
inprogress         hp_pc         tiket edited(16-04-15)           096
open               tiwa_pc       tiket edited(15-04-15)           123
closed             hp_pc         tiket edited(14-04-15)           123
open               fdi_pc        tiket edited(18-04-15)           124
open               tiwa_pc       tiket edited(15-04-15)           123

For example:
I want to change status="open" to status="new" (note that all can be repeated).
How can do it?

thanks

Re: How to change a specific value of a field in my events to another value in a search?

aweitzman — Fri, 17 Apr 2015 15:53:37 GMT

This ought to get you what you want:

... | eval status=if(status="open","new",status)

Re: How to change a specific value of a field in my events to another value in a search?

Raghav2384 — Fri, 17 Apr 2015 15:56:32 GMT

+1 to the above answer.

You can also try something like

....|replace "open" with "new" in status?

Thanks,
Raghav

Re: How to change a specific value of a field in my events to another value in a search?

stephane_cyrill — Fri, 17 Apr 2015 15:59:58 GMT

Hi fdi01,

To do what you need you can use the rex command with mode=sed option like this:

... | rex field=fieldName mode=sed "s/your_regex/your_replacement_string/g"

What you have to do is to filter the event as you like> doing this you will replace the match expression by the replacement string

Re: How to change a specific value of a field in my events to another value in a search?

fdi01 — Sat, 18 Apr 2015 16:31:50 GMT

thank raghav
it change all value of status
but i am filtering. very thank of you information with replace command.

Re: How to change a specific value of a field in my events to another value in a search?

vcgamesii — Mon, 21 Dec 2015 22:28:28 GMT

If anyone is wondering about the timing of the 3 commands above (rex, replace, eval), I tested on my own dataset and results are:

rex probably fastest, with rex and eval both taking about 1s in fast mode, but taking about 4s in verbose mode.
replace takes about 4s in both fast and verbose mode

Re: How to change a specific value of a field in my events to another value in a search?

srinivas_gowda — Fri, 04 Feb 2022 05:25:38 GMT

Just another doubt on the same kind here, what if all values do not have "open" and we will have to search to remove only the value "open" while retain its other fields and values?