CLI CSV editor #
CSVfix is a command-line CSV editor. Features include:
- Convert fixed format, multi-line and DSV files to CSV
- Reorder, remove, split and merge fields
- Convert case, trim leading & trailing spaces
- Search for specific content using regular expressions
- Filter out duplicate data or data on exclusion lists
- Perform sed/perl style editing
- Enrich with data from other sources
- Add sequence numbers and file source information
- Split large CSV files into smaller files based on field contents
- Perform arithmetic calculations on individual fields
- Validate CSV data against a collection of validation rules
- Convert between CSV and fixed format, XML, SQL and DSV
- Summarise CSV data, calculating averages, modes, frequencies etc.
Install from source (*nix/Win) or binary (Win only).
/nix | Jun 13, 2012
Subscribe or visit the archives.