Splunk Search

field value is a whitespace

wtaylor149
Explorer

I have a field that sometimes has only what appears to be a whatspace.  How would I replace the existing whitespace with a value of "none"?

Labels (1)
0 Karma

thambisetty
SplunkTrust
SplunkTrust

| rex field=yourfield “/s/^\s$/yourvaluetoreplace/g”

 

Note: dont copy paste. The above solution works only if there is whitespace

————————————
If this helps, give a like below.
0 Karma

wtaylor149
Explorer

Thanks for the quick response but that did not work, even after I fixed the sed structure.

0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...