csvq is a CLI package for parsing and transforming CSV files. This is useful because often trimming down a CSV file can make processing it easier.
Download the latest release for your architecture.
Extract first_name and last_name columns (in that order). Sort results.
csvq -keep first_name,last_name ~/Downloads/report.csv | sort -u
Change delimiter used in report.csv.
csvq -d';' user_id,dob,email ~/Downloads/report.csv
Output CSV columns in a table.
csvq -keep first_name,last_name -format table
Combine multiple files.
csvq -keep user_id,email ~/Downloads/report1.csv ~/Downloads/report2.csv
- 64-bit Linux (Ubuntu, Debian), macOS, and Windows
Apache License 2.0 - See LICENSE for details.