Can you help me replace one slash with "_" so I can extract a field?

[WXY]

Hi.

I want to get a field.

Now this field named location_code contains "/" such as "/home/name/p"

I want to replace the "/" with "_" so I can match another field value,

What should I do ?

[mstjohn_splunk]

hi @wxy,

Did the answer below solve your problem? If so, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help ya. Thanks for posting!

[burwell · Accepted solution]

Hi @WXY

You probably want to use the replace command.

Let's create a test field called foo and then a new field called changed to illustrated how to use replace.

index=<your search here> 
| eval foo="a/b"
|eval changed=replace(foo,"/","_")
|table foo,changed