Convert a tab de-limited mysql export to csv

tab-to-csv.sh

# Strategy:
# Remove all double quotes.
# Replace all tabs with double-quotes on either side of a comma.
# Add double-quotes to the beginning and the end of the line.

# Debian

sed -e 's/\"//g' -e 's/\t/\",\"/g'  -e 's/^/\"/' -e 's/$/\"/' filename.tab > filename.csv

# OS X: The \t needs to be replaced by CTRL+v followed by a tab.

sed -e 's/\"//g' -e 's/        /\",\"/g'  -e 's/^/\"/' -e 's/$/\"/' filename.tab > filename.csv