Splunk Search

how to set null value ?

WXY
Path Finder

If the field value is null, the value is null, and if it is not controlled, it is still the original value

I want to get a field value ,if it is null ,I set it null,if not ,I hope it still the original value

I use :

index = abc_text  | eval Codelocation = if(isnull(Codelocation), "null",Codelocation)|stats  max(_time) as _time  values(Codelocation) as codelocation by source

It did not achieve the desired effect.

Tags (3)
0 Karma

zihenggong
Engager

use null() instead of "null"

renjith_nair
Legend

@WXY, just a clarification - if the value is null why do you want to set it again to null ? Do you mean you want to convert "space" to null.

Anyway try this |eval Codelocation = if(isnull(Codelocation), null(),Codelocation)

---
What goes around comes around. If it helps, hit it with Karma 🙂
Get Updates on the Splunk Community!

Splunk Observability Synthetic Monitoring - Resolved Incident on Detector Alerts

We’ve discovered a bug that affected the auto-clear of Synthetic Detectors in the Splunk Synthetic Monitoring ...

Video | Tom’s Smartness Journey Continues

Remember Splunk Community member Tom Kopchak? If you caught the first episode of our Smartness interview ...

3-2-1 Go! How Fast Can You Debug Microservices with Observability Cloud?

3-2-1 Go! How Fast Can You Debug Microservices with Observability Cloud? Learn how unique features like ...