https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418138#M167238 <P>Hi leninkp3005,</P> <P>You can use field!=null for this one. <BR /> If you want to use those null fields you can use fillnull command<BR /> fillnull fills all the null values in the results of a specific field/fields/all fields with a value (defaulted as 0)<BR /> |fillnull FIELD value="N/A"</P> Fri, 05 Oct 2018 20:50:53 GMT iamarkaprabha 2018-10-05T20:50:53Z https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418136#M167236 <P>Folks !!</P> <P>I'm struggling with removing empty rows from the result fields in my results. In my results, i've got many empty rows. </P> <P>Kindly assist this case.</P> <P>Unable to upload/attach my sheet, sorry for the inconvenience.</P> <P>Cheers,<BR /> Lenin K</P> Fri, 05 Oct 2018 17:22:09 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418136#M167236 leninkp3005 2018-10-05T17:22:09Z https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418137#M167237 <P>@leninkp3005</P> <P>you can use where or search after your result.</P> <P><CODE>|where isnotnull(field1)</CODE></P> <P>OR</P> <P><CODE>|search field1=*</CODE></P> Fri, 05 Oct 2018 17:44:59 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418137#M167237 kamlesh_vaghela 2018-10-05T17:44:59Z https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418138#M167238 <P>Hi leninkp3005,</P> <P>You can use field!=null for this one. <BR /> If you want to use those null fields you can use fillnull command<BR /> fillnull fills all the null values in the results of a specific field/fields/all fields with a value (defaulted as 0)<BR /> |fillnull FIELD value="N/A"</P> Fri, 05 Oct 2018 20:50:53 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418138#M167238 iamarkaprabha 2018-10-05T20:50:53Z https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418139#M167239 <P>Hello Kamlesh,</P> <P>It's working for me, thanks for your support.</P> <P>Cheers,<BR /> Lenin Kp</P> Mon, 15 Oct 2018 17:25:18 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418139#M167239 leninkp3005 2018-10-15T17:25:18Z https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418140#M167240 <P>Hi,<BR /> Used that last query. It's working fine.</P> <P>Thanks.</P> Mon, 15 Oct 2018 17:26:23 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418140#M167240 leninkp3005 2018-10-15T17:26:23Z https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418141#M167241 <P>You are welcome!</P> Thu, 18 Oct 2018 15:00:50 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-remove-empty-rows-in-the-result-fields/m-p/418141#M167241 iamarkaprabha 2018-10-18T15:00:50Z