kevinhq · April 25, 2020 11:20 · Oct 21, 2016 · Oct 21, 2016
diff --git a/README.md b/README.md
@@ -0,0 +1,4 @@
+# pretty_csv/pretty_tsv
+These are some simple bash functions and scripts for making CSV/TSV files prettier on the command line
+
+see [http://stefaanlippens.net/pretty-csv.html](http://stefaanlippens.net/pretty-csv.html) for more information.
diff --git a/pretty_csv_bash_functions.sh → bash_functions.sh b/pretty_csv_bash_functions.sh → bash_functions.sh
diff --git a/pretty_csv.sh b/pretty_csv.sh
@@ -0,0 +1,2 @@
+#!/bin/bash
+perl -pe 's/((?<=,)|(?<=^)),/ ,/g;' "$@" | column -t -s, | exec less  -F -S -X -K
diff --git a/pretty_csv_bash_functions.sh b/pretty_csv_bash_functions.sh
@@ -0,0 +1,19 @@
+##################################################### 
+# Bash functions to put in .bashrc or .bash_aliases #
+#####################################################
+
+# For Debian/Ubuntu
+function pretty_csv {
+    column -t -s, -n "$@" | less -F -S -X -K
+}
+function pretty_tsv {
+    column -t -s $'\t' -n "$@" | less -F -S -X -K
+}
+
+# For non-Debian systems
+function pretty_csv {
+    perl -pe 's/((?<=,)|(?<=^)),/ ,/g;' "$@" | column -t -s, | less  -F -S -X -K
+}
+function pretty_tsv {
+    perl -pe 's/((?<=\t)|(?<=^))\t/ \t/g;' "$@" | column -t -s $'\t' | less  -F -S -X -K
+}
diff --git a/pretty_tsv.sh b/pretty_tsv.sh
@@ -0,0 +1,2 @@
+#!/bin/bash
+perl -pe 's/((?<=\t)|(?<=^))\t/ \t/g;' "$@" | column -t -s $'\t' | exec less  -F -S -X -K
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		#!/bin/bash
		perl -pe 's/((?<=,)\|(?<=^)),/ ,/g;' "$@" \| column -t -s, \| exec less -F -S -X -K
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		#!/bin/bash
		perl -pe 's/((?<=\t)\|(?<=^))\t/ \t/g;' "$@" \| column -t -s $'\t' \| exec less -F -S -X -K