New: Try Voli The Bear, Fast package manager (and not only) for Windows
Reference

Cheat Sheet

The commands you keep forgetting, with a one-line description and a real example you can copy - 629 across 38 tools. Pick a tool in the sidebar, or search across all of them.

awk

Process columns and compute over text - the one-liners people actually use.
CommandWhat it doesExample
awk print columnPrint a field (fields are 1-indexed).awk '{print $2}' access.log
awk -FSet the field separator, e.g. for CSV.awk -F, '{print $1}' users.csv
awk $NFPrint the last field on each line.awk '{print $NF}' access.log
awk filterPrint rows where a column passes a test.awk '$3 > 100' sales.txt
awk /pattern/Print lines matching a regex.awk '/ERROR/' app.log
awk match + fieldCombine a pattern with a column to print.awk '/ERROR/ {print $1, $4}' app.log
awk sumSum a column.awk '{s += $1} END {print s}' nums.txt
awk averageAverage a column (NR = row count).awk '{s += $1} END {print s/NR}' latencies.txt
awk NRUse the line number - print one line.awk 'NR == 5' file.txt
awk NR > 1Skip the header row.awk 'NR > 1' report.csv
awk count valuesCount how often each value appears.awk '{c[$1]++} END {for (k in c) print k, c[k]}' ips.txt
awk dedupeDrop duplicate lines without sorting first.awk '!seen[$0]++' emails.txt
awk with textMix fields with literal text.awk '{print "id:", $1}' users.txt
awk NFNF = field count; find malformed rows.awk 'NF != 4' data.tsv
awk length()Filter by line length.awk 'length($0) > 80' main.py
awk OFSChange the output separator (CSV to TSV).awk -F, 'BEGIN {OFS="\t"} {print $1, $3}' users.csv