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!

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

Happy CX Day, Splunk Community!

Happy CX Day, Splunk Community! CX stands for Customer Experience, and today, October 3rd, is CX Day — a ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...