Monitoring Splunk

Removing "+" from the result

runiyal
Path Finder

My logfile has a columns "myField" and logfile has something like this - 

&myField=I+need+assistance+with+myPolicy.+My+question+is+Question+1+-+What+is+the+value+of+ABC+Insurance+as+listed+in+Stock+market+

I am able to set the value in my table but how can I remove "+".

seems like replace "+" WITH "" IN myField is not working.

 

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

The replace command only replaces the first occurrence - try 

| eval myField=replace(myField, "\+", " ")

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

The replace command only replaces the first occurrence - try 

| eval myField=replace(myField, "\+", " ")

View solution in original post

0 Karma
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!