topic rex mode=sed syntax in Splunk Search

rex mode=sed syntax

cschafer1 — Thu, 03 Oct 2013 19:29:58 GMT

I apolagize for the simplicity of this question. I have scowered all over splunk answers and could find or make sense of a solutions from what I have found.

I need to remove %20 from my search and replace with a space. I have tried:

rex mode=sed "s/%20/ /"
rex mode=sed "s/%20/ /g"
rex mode=sed field=fieldname "s/%20/ /g"

I am sure it is not registering with me whith the slashes what is needed in the sed sytax.

Thank you for any assistance.

Cory

Re: rex mode=sed syntax

Ayn — Thu, 03 Oct 2013 19:37:48 GMT

That's really how you would do it with rex mode=sed so I really don't know why it's not working for you. However I suggest an alternate solution that seems more appropriate in your scenario anyway: use eval's urldecode function instead. It will read a string, decode all URL encoded entities and return the decoded string.

... | eval yourfield=urldecode(yourfield)

Re: rex mode=sed syntax

cschafer1 — Thu, 03 Oct 2013 20:17:06 GMT

That worked... Thank you very much.

Re: rex mode=sed syntax

Ayn — Thu, 03 Oct 2013 20:25:50 GMT

Awesome. Could you please mark my answer as accepted (click the tick mark on the left)? Thanks!