category 01 / 10

Text processing

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

002

entries

4 min

avg read

all 002 awk 001 logs 001 aggregation 001 arrays 001 sort 001 csv 001 text 001

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 002 of 002