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!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...