Zfind
search for files (even inside tar/zip/7z/rar) using a SQL-WHERE filter
Install / Use
/learn @laktak/ZfindREADME
zfind
{ repos & mirrors: github.com/laktak/zfind, codeberg.org/laktak/zfind }
zfind allows you to search for files, including inside tar, zip, 7z and rar archives. It makes finding files easy with a filter syntax that is similar to an SQL-WHERE clause. This means, if you know SQL, you don't have to learn or remember any new syntax just for this tool.
- Basic Usage & Examples
- Where Syntax
- Properties
- Supported archives
- Actions
- Configuration
- Installation
- zfind as a Go module
Basic Usage & Examples
zfind <where> [<path>...]
Examples
# find files smaller than 10KB, in the current path
zfind 'size<10k'
# find files in the given range in /some/path
zfind 'size between 1M and 1G' /some/path
# find files modified before 2010 inside a tar
zfind 'date<"2010" and archive="tar"'
# find files named foo* and modified today
zfind 'name like "foo%" and date=today'
# find files that contain two dashes using a regex
zfind 'name rlike "(.*-){2}"'
# find files that have the extension .jpg or .jpeg
zfind 'ext in ("jpg","jpeg")'
# find directories named foo and bar
zfind 'name in ("foo", "bar") and type="dir"'
# search for all README.md files and show in long listing format
zfind 'name="README.md"' -l
# show results in csv format
zfind --csv
zfind --csv-no-head
Where Syntax
AND,ORand()parentheses are logical operators used to combine multiple conditions.ANDmeans that both conditions must be true for a row to be included in the results.ORmeans that if either condition is true, the row will be included. Parentheses are used to group conditions, just like in mathematics.
Example: '(size > 20M OR name = "temp") AND type="file"' selects all files that are either greater than 20 MB in size or are named temp.
- Operators
=,<>,!=,<,>,<=,>=are comparison operators used to compare values and file properties. The types must match, meaning don't compare a date to a file size.
Example: 'date > "2020-10-01"' selects all files that were modified after the specified date.
LIKE,ILIKEandRLIKEare used for pattern matching in strings.LIKEis case-sensitive, whileILIKEis case-insensitive.- The
%symbol is used as a wildcard character that matches any sequence of characters. - The
_symbol matches any single character. RLIKEallows matching a regular expression.
Example: '"name like "z%"' selects all files whose name starts with 'z'.
INallows you to specify multiple values to match. A file will be included if the value of the property matches any of the values in the list.
Example: '"type in ("file", "link")' selects all files of type file or link.
BETWEENselects values within a given range (inclusive).
Example: '"date between "2010" and "2011-01-15"' means that all files that were modified from 2010 to 2011-01-15 will be included.
NOTis a logical operator used to negate a condition. It returns true if the condition is false and vice versa.
Example: '"name not like "z%"', '"date not between "2010" and "2011-01-15"', '"type not in ("file", "link")'
- Values can be numbers, text, date and time,
TRUEandFALSE- dates have to be specified in
YYYY-MM-DDformat - times have to be specified in 24h
HH:MM:SSformat - numbers can be written as sizes by appending
B,K,M,GandTto specify bytes, KB, MB, GB, and TB. - empty strings and
0evaluate tofalse
- dates have to be specified in
Properties
The following file properties are available:
| name | description |
|-------------|-------------------------------------------------------------------|
| name | name of the file |
| path | full path of the file |
| container | path of the container (if inside an archive) |
| size | file size (uncompressed) |
| date | modified date in YYYY-MM-DD format |
| time | modified time in HH-MM-SS format |
| ext | short file extension (e.g., txt) |
| ext2 | long file extension (two parts, e.g., tar.gz) |
| type | file, dir, or link |
| archive | archive type: tar, zip, 7z, rar or empty |
Helper properties
| name | description | |-------------|-------------------------------------------------------------------| | today | today's date | | mo | last monday's date | | tu | last tuesday's date | | we | last wednesday's date | | th | last thursday's date | | fr | last friday's date | | sa | last saturday's date | | su | last sunday's date |
Supported archives
| name | extensions |
|-------------|-------------------------------------------------------------------|
| tar | .tar, .tar.gz, .tgz, .tar.bz2, .tbz2, .tar.xz, .txz |
| zip | .zip |
| 7zip | .7z |
| rar | .rar |
Note: use the flag -n (or --no-archive) to disable archive support. You can also use
'not archive'in your query but this still requires zfind to open the archive.
Actions
zfind does not implement actions like find, instead use xargs -0 to execute commands:
zfind --no-archive 'name like "%.txt"' -0 | xargs -0 -L1 echo
zfind can also produce --csv (or --csv-no-head) that can be piped to other commands.
Configuration
Set the environment variable NO_COLOR to disable color output.
Installation
Install/Update Binaries
curl https://laktak.github.io/zfind.sh|bash
This will download the zfind binary for your OS/Platform from the GitHub releases page and install it to ~/.local/bin. You will get a message if that's not in your PATH.
You probably want to download or view the setup script before piping it to bash.
If you prefer you can download a binary from github.com/laktak/zfind/releases manually and place it in your PATH.
Prereleased versions can be found directly on the GitHub Action. Click on the latest ci action and look for prerelease-artifacts at the bottom.
Homebrew (macOS and Linux)
For macOS and Linux it can also be installed via Homebrew:
brew install zfind
Arch Linux
zfind is available in the AUR as zfind:
paru -S zfind
Build from Source
Building from the source requires Go.
- Either install it directly
go install github.com/laktak/zfind/cmd/zfind@latest
- or clone and build
git clone https://github.com/laktak/zfind
zfind/scripts/build
# output is here:
zfind/zfind
zfind as a Go module
zfind is can also be used in other Go programs.
go get github.com/laktak/zfind
The library consists of two main packages:
- filter: provides functionality for parsing and evaluating SQL-where filter expressions
- find: implements searching for files and directories.
For more information see the linked documentation on pkg.go.dev.
