Splunk Search

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

WXY
Path Finder

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 ?

Tags (2)
0 Karma
1 Solution

burwell
SplunkTrust
SplunkTrust

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

View solution in original post

0 Karma

mstjohn_splunk
Splunk Employee
Splunk Employee

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!

0 Karma

burwell
SplunkTrust
SplunkTrust

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
0 Karma
Get Updates on the Splunk Community!

Best Strategies to Optimize Observability Costs

 Join us on Tuesday, May 6, 2025, at 11 AM PDT / 2 PM EDT for an insightful session on optimizing ...

Fueling your curiosity with new Splunk ILT and eLearning courses

At Splunk Education, we’re driven by curiosity—both ours and yours! That’s why we’re committed to delivering ...

Splunk AI Assistant for SPL 1.1.0 | Now Personalized to Your Environment for Greater ...

Splunk AI Assistant for SPL has transformed how users interact with Splunk, making it easier than ever to ...