awk is one of my favorite utilities. It's my go-to tool for any ad-hoc data reformatting and quick reports. My latest use was taking CSV files of transaction data from WePay and creating ledger [1] entries.
sed is pretty cool too but it feels a lot more arcane to me than awk.