How to hide items with empty values in select column. Especially w/ Find Column Duplicates.

Discussion related to "Everything" 1.5 Alpha.
Post Reply
raccoon
Posts: 1017
Joined: Thu Oct 18, 2018 1:24 am

How to hide items with empty values in select column. Especially w/ Find Column Duplicates.

Post by raccoon »

Are there any clicks or search verbs that can be used to hide items with a blank value in a specified column?

This would be especially useful when using the Find Duplicates (find-dupes:) column feature, since "blank" vs "blank" are duplicate items too. But it would also be useful for any results [not just dupes] that I wish to export or sub-search. Maybe the search term hide-empty:<col-name>

(also, find-dupes:<col-name> without the required sort:<col-name> would be a nifty abbreviation)
therube
Posts: 4955
Joined: Thu Sep 03, 2009 6:48 pm

Re: How to hide items with empty values in select column. Especially w/ Find Column Duplicates.

Post by therube »

I've got a
!length:null
in my history.
What that looks to do is to is to remove files that have 00:00 returned as their length.

What that does not do is to remove files that do not display a length at all (i.e., Length column for a particular file does not display anything at all).

You can do something like
!length:<00:02
to remove files that display as 00:01 or 00:00 (but again not files that do not display a length at all).


Looking more, I'm not sure how "correct" the above is?
NotNull
Posts: 5458
Joined: Wed May 24, 2017 9:22 pm

Re: How to hide items with empty values in select column. Especially w/ Find Column Duplicates.

Post by NotNull »

raccoon wrote: Thu Oct 21, 2021 7:38 pm Are there any clicks or search verbs that can be used to hide items with a blank value in a specified column?
Example with column "Regular Expression Match 1"; replace with actual column name:

- Right-click the Regular Expression Match 1 column header and choose Search for Regular Expression Match 1
- In the Everything search bar regular-expression-match-1: will be shown
- Precede it with a "!" to query filenames that do NOT have that property deined: !regular-expression-match-1:
- Done.
raccoon
Posts: 1017
Joined: Thu Oct 18, 2018 1:24 am

Re: How to hide items with empty values in select column. Especially w/ Find Column Duplicates.

Post by raccoon »

Huh, interesting! So the column name as a verb itself.

extension: -- only shows items that DO have an extension. (not blank)
!extension: -- only shows items that do NOT have an extension. (is blank)

regular-expression-match-2: -- only shows items that DO have a second regex backref match component. (not blank).
!regular-expression-match-2: -- only shows items that do NOT have a second regex backref match component. (is blank)

sha512sum-sha-512: -- only shows items that DO have an SHA-512 digest file.
!sha512sum-sha-512: -- those that do NOT.

OK. I get it now. Thanks. :)
void
Developer
Posts: 16672
Joined: Fri Oct 16, 2009 11:31 pm

Re: How to hide items with empty values in select column. Especially w/ Find Column Duplicates.

Post by void »

!length:null

is the same as:

!length:00:00

is the same as:

!length:0



Short answer, use:
length:
to find files with a valid length value.

and use:
!length:
to find files with an unknown length value.



Technical info:

With most properties in Everything, the maximum value is reserved for unknown (display nothing)
String property values will use the empty string for unknown. (does not distinguish between a valid empty string and an unknown value)
Unknown might mean that Everything is still gathering information for this property or the property doesn't exist.

Use the keyword unknown to find these properties.
For example:
length:unknown



For properties with numerical values (BYTE/WORD/DWORD/QWORD), property: will match property values of 0..(max value - 1)
For properties with boolean values (BYTE), property: will match property values of 1..254
For properties with string values, property: will match property values with a length greater than 0

Internally, length: will match a QWORD value of 0 to 0xfffffffffffffffe (inclusive)
Internally, a length value of 0xffffffffffffffff denotes an unknown length.
Post Reply