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, "\+", " ")
0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...