delete events that have a certain field empty?

[halperkins]

here is the scenario:
http://tinypic.com/r/1ax08/6

how can i delete the events for which the field is empty?

thanks

EDIT:
btw, i do not want to do the "delete" command which would delete the data from the actual server. I just want it removed from the search result

[martin_mueller]

In order to remove events from the search result when field is empty you could just add field=* to your search.

[martin_mueller]

field=* means "field is anything but empty".

[horsefez]

@martin_mueller
How is this right?
For my understanding this means the fields value could by anything.

[sowings]

| where isnull(<field>)

[gfrjonp]

• Edit, didnt read all the way, above is correctomundo.

source= | where isnull(B)

[sirisk]

It worked for me