Splunk Search

how toreplace all the existing blank fields values with some name using replace command

vrmandadi
Builder

I have data coming from a csv file .it has almost 30 fields and some of it values are blank.How I replace the empty fields or no value fields for all the fields with some value

I tried using
| replace "" WITH "abc" IN * but it does not work .If i give a field name then it works . I tried using fillnull command but that did not work

0 Karma

vnravikumar
Champion

Hi

Try this

| makeresults 
| eval field1="a",field2="",field3="3",field4="b" 
| append 
    [| makeresults 
    | eval field1="",field2="",field3="",field4="b"] 
| replace "" with "NA"
0 Karma
Get Updates on the Splunk Community!

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...

Updated Team Landing Page in Splunk Observability

We’re making some changes to the team landing page in Splunk Observability, based on your feedback. The ...

New! Splunk Observability Search Enhancements for Splunk APM Services/Traces and ...

Regardless of where you are in Splunk Observability, you can search for relevant APM targets including service ...