csvCol

csvCol

shows/hides columns of csv files

Getting Started

Build the executable with go build.

./csvCol --help will give you this:

Usage of csvCol:
  -C value
        list of columns to show by name
  -c value
        list of columns to show
  -f string
        path to input file instead of stdin
  -s string
        separator character (defaults to a comma) (default ",")
  -v    hide (instead of showing) the columns that were selected

Examples

• show the first two columns:

./csvCol -c=0 -c=1 -f="./customers.csv"

• show all columns except the first two:

./csvCol -v -c=0 -c=1 -f="./customers.csv"

• show specific column by name

./csvCol -C="email" -f="./customers.csv"

• find duplicate emails

./csvCol -f="customers.csv" -C="email" | sort | uniq -c | grep -v -e"^\s*1[^\d]" | sort -nr

Built With

• Golang - The go language