How to remove white spaces in field value?

hariniramesh · ‎11-19-2019

I am having an field name called "JOBNAME" which contains some jobname values and some empty values(which means there is no value in some of the rows). How to remove the empty values and show only values with jobname?

richgalloway · ‎11-19-2019

Try ... | where isnotnull(JOBNAME) | ....

---
If this reply helps you, Karma would be appreciated.

How to remove white spaces in field value?

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Accelerating Observability as Code with the Splunk AI Assistant

Join the Conversation

How to remove white spaces in field value?

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Accelerating Observability as Code with the Splunk AI Assistant