CSV

Docker container to run CSV manipulation utitilies (csvkit...).

Example not using the filesystem

Let's say that you have a CSV file foo.csv and that you want to extract the column named bar:

Mac/Linux

cat foo.csv | docker run --rm -i --net=none leplusorg/csv csvsql --table foo --query "select bar from foo"

Windows

type foo.csv | docker run --rm -i --net=none leplusorg/csv csvsql --table foo --query "select bar from foo"

Example using the filesystem

Same thing, assuming that you have a CSV file foo.csv and that you want to extract the column named bar:

Mac/Linux

docker run --rm -t --user="$(id -u):$(id -g)" --net=none -v "$(pwd):/tmp" leplusorg/csv csvsql --query "select bar from foo" /tmp/foo.csv

Windows

In cmd:

docker run --rm -t --net=none -v "%cd%:/tmp" leplusorg/csv csvsql --query "select bar from foo" /tmp/foo.csv

In PowerShell:

docker run --rm -t --net=none -v "${PWD}:/tmp" leplusorg/csv csvsql --query "select bar from foo" /tmp/foo.csv

Help

To know more command-line options of one of the csvtk command:

docker run --rm --net=none leplusorg/csv csvsql -h

Request new tool

Please use this link (GitHub account required) to request that a new tool be added to the image. I am always interested in adding new capabilities to these images.