csv_transform

Collection of operations on CSV files.

The CSV operations can either involve transforming one CSV into an other, in what we call map-like or 1:1 transforms, or they can transform several CSVs files into one or more different CSVs, in what we call reduce-like or N:M transforms. Note that operationns like splitting (1:N) or merging (N:1) are particular cases of the reduce transforms.

The transformations can be easily combined, either using the csv_transformer command-line tool or programmatically.

This toolkit is intended to be easily extensible by adding new operations, as the need arise.

Changelog

• 1.1 - --deletecol and --split transform modes
• 1.2 - --exclude and post-processing
• 1.3 - modes can be combined, --exclude + `--deletecol
• 1.4 - Schober milestone, stable and tested
• 1.5 - Schober fix, added --no-headers support
• 1.6 - Schober fix, added --quote support (no quote otherwise)
• 1.7 - Schober bom.csv, added --groupmerge support
• 1.8 - Gem packaging
• 1.9 - Bruckner grep -v mode (--invert-match actually)
• 1.10 - columns can be specified by name
• 1.11 - detailed command help can be obtained with -h --
• 1.12 - better logging (use CmdUtil 2.0)
• 1.13 - Metaldyne filter-in mode (i.e. filterout --invert-match)
• 1.14 - improved logging again, use CmdUtil 3.2
• 1.15 - writing a CSV with no rows still generates a row of headers
• 1.16 - Foboha ad-hoc extensions to the --merge mode