csv-exec 0.1.0

csv-exec runs a command for each line of a CSV file. The command's arguments are replaced by the value of the CSV columns. The output is written in a new column.

$ cat test.csv
Id,Dir
24,example.com/a
68,example.com/b

$ csv-exec --exec 'echo $1/$0' <test.csv
Id,Dir,Result
24,example.com/a,example.com/a/24
68,example.com/b,example.com/b/68

The regex that parses the arguments can be changed:

$ csv-exec --exec 'echo €1/€0' --arg-regex '€([0-9]+)' <test.csv
Id,Dir,Result
24,example.com/a,example.com/a/24
68,example.com/b,example.com/b/68

The help, generated by clap:

$ csv-exec -h
csv-exec 0.1.0
niladic <git@nil.choron.cc>
Execute a command on each record of a CSV.

USAGE:
    csv-exec [FLAGS] [OPTIONS] --exec <COMMAND>

FLAGS:
    -h, --help         Prints help information
    -n, --no-header    Do not read the first line as a header line
    -V, --version      Prints version information

OPTIONS:
        --arg-regex <REGEX>           Regex used to parse the column position in the command args. Syntax:
                                      https://docs.rs/regex/1.3.4/regex/index.html#syntax [default: \$([0-9]+)]
    -d, --delimiter <CHAR>            CSV delimiter (\t for tabs) [default: ,]
    -e, --exec <COMMAND>              The command to execute
    -i, --input <FILE>                Input CSV file [stdin by default]
        --new-column-name <STRING>    Name of the new column which contains the results [default: Result]
    -o, --output <FILE>               Output CSV [stdout by default]
        --quote <CHAR>                CSV quote [default: "]