topic Why isn't my replace command working in this search? in Splunk Search

Why isn't my replace command working in this search?

nisha_kapoor — Thu, 10 Aug 2017 19:00:20 GMT

index=test TransactionId="xxx-xxx-xxx"|  replace "000" with "" in Status| fields Status

I want to replace the first occurrence of "000" in status to blank.This is the command I wrote after referring to Splunk Documentation. However, the results don't show me the modified value of Status. Is there something missing in the command?

My end result should be the value of Status with "000" replaced.

Thanks for your help

Re: Why isn't my replace command working in this search?

cmerriman — Thu, 10 Aug 2017 19:06:35 GMT

try a regex command:

|rex field=Status mode=sed "s/000//g"

Re: Why isn't my replace command working in this search?

somesoni2 — Thu, 10 Aug 2017 19:24:52 GMT

Try like this

 index=test TransactionId="xxx-xxx-xxx"| eval Status=replace(Status,"^000(.+)","\1") | fields Status

Re: Why isn't my replace command working in this search?

sbbadri — Thu, 10 Aug 2017 20:28:55 GMT

try this

index=test | eval TransactionId="xxx-xxx-xxx" | replace *000* with ** in Status