category 01 / 10

Text processing

Sorting, filtering, reformatting, and slicing text from the terminal.

005

entries

3 min

avg read

all 005 csv 003 text 002 tail 001 headers 001 jq 001 json 001 filtering 001 column 001 tables 001 formatting 001 awk 001 logs 001 aggregation 001 arrays 001 sort 001

047Skip the header line of a file before you sort or count ittail -n +2 sales.csv2026-10-233 min 035Pull only the matching records out of a JSON filejq -r '.servers[] | select(.cpu > 60) | [.name, .ip, .cpu] | @tsv' data.json2026-10-024 min 030Line up a CSV into readable columns right in the terminalcolumn -s, -t sales.csv2026-09-253 min 022Total a column grouped by another one in a single passawk '{n[$7]++; bytes[$7]+=$10} END {for (u in n) printf "%12.0f %6d %s\n", bytes[u], n[u], u}' access.log | sort -rn | head2026-09-154 min 007Sort a CSV by any column without opening a spreadsheetsort -t, -k3 -nr sales.csv | head -202026-08-243 min

showing 005 of 005