Removing "+" from the result

[runiyal]

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.

[ITWhisperer · Accepted solution]

The replace command only replaces the first occurrence - try 

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