CSVfix

CSVfix is a command-line tool specifically designed to deal with CSV data. With it you can, convert fixed format, multi-line and DSV files to CSV, record, remove, split and merge fields, convert case, trim leading and trailing spaces, search for specific content using regular expressions, filter out duplicate data or data on exclusion lists, 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, and convert between CSV and fixed format, XML, SQL and DSV.