Splunk Search

How to replace slash characters in field values with spaces instead (ex: change "A/B/C/D" to "A B C D")?

arnabsen1234
New Member

I have a field named httpUrl. This field has values with slashes like "/document/import/upload/reload/". I want to replace all the slashes with spaces. So the final thing should look like httpUrl="document import upload reload". How do I achieve this?

Tags (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Try ... | eval httpUrl=replace (httpUrl,"/"," ") | ...

---
If this reply helps you, Karma would be appreciated.

MuS
Legend

Hi arnabsen1234,

try something like this:

| gentimes start=-1 | eval httpUrl="document/import/upload/reload" | rex field=httpUrl mode=sed "s/\// /g"

cheers, MuS

Get Updates on the Splunk Community!

Leveraging Detections from the Splunk Threat Research Team & Cisco Talos

  Now On Demand  Stay ahead of today’s evolving threats with the combined power of the Splunk Threat Research ...

New in Splunk Observability Cloud: Automated Archiving for Unused Metrics

Automated Archival is a new capability within Metrics Management; which is a robust usage & cost optimization ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...