linux:csv [inn]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

=== column ===
Using a great command line toot ''column'', it is easy to view the content of tab/comma separated files in a readable format.

Format CSV ',' as tabular output
  column -t -s,' < your_file.csv

Format TSV :
  column -ts $'\t' < your_file.tsv

Pipe the output to ''less''
  column -ts $'\t' < your_file | less

Put that in a script, for example ''~/bin/tsvview''
<code bash tsvview.sh>
#!/bin/bash

set -o errexit

function show_usage {
  cat <<EOF
Usage: $0 [--help] [filename]
View a TSV file at the command line.
  --help        Show this help text.
  filename      CSV file to be viewed
EOF
  exit -1
}

if [ "$1" == "--help" -o "$1" == "" ]; then
  show_usage
fi

column -ts $'\t' < "$1" | less -#.3 -N -S
</code>

Make an alias
 alias tv='tsvview'

or a function
<code bash>
function tsv {
  column -ts $'\t' < "$1" | less -#.3 -N -S
}
</code>