http://robertheaton.com/2015/08/31/migrating-bajillions-of-database-records-at-stripe/
I like reading these types of stories about how the sausage is made.
http://robertheaton.com/2015/08/31/migrating-bajillions-of-database-records-at-stripe/
I like reading these types of stories about how the sausage is made.
http://neilb.bitbucket.org/csvfix/ ᔥ
CSVfix is a command-line tool specifically designed to deal with CSV data. With it you can, among other things:
- 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
- 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