topic Re: How to replace slash characters in field values with spaces instead (ex: change "A/B/C/D" to "A B C D")? in 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 — Sun, 21 Jun 2015 22:40:16 GMT

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?

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

MuS — Sun, 21 Jun 2015 22:55:29 GMT

Hi arnabsen1234,

try something like this:

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

cheers, MuS

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

richgalloway — Sun, 21 Jun 2015 23:05:35 GMT

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