tsv2csv

#!/bin/bash
# Script uses LibreOffice Calc in headless mode to convert a tab-separated values file
# to a comma-separated values file. Also replaces MySQL NULLs with empty string.
if [[ $# -ne 1 ]]; then
  echo "usage: `basename $0` filename"
  echo "where 'filename' is a file of tab-separated values. 'filename' will be converted"
  echo "to comma-separated values and renamed 'filename.bak'."
  exit 1
fi
LIBRE_PATH=`which scalc`
[ -z "$LIBRE_PATH" -a -x "/Applications/LibreOffice.app/Contents/MacOS/soffice" ] && LIBRE_PATH="/Applications/LibreOffice.app/Contents/MacOS/soffice"
if [ -f $1 ]; then
  $LIBRE_PATH --headless --infilter="Text - txt - csv (StarCalc):9,34,0,1," \
    --convert-to csv:"Text - txt - csv (StarCalc):44,34,0,1," \
    --outdir /tmp $1
  mv $1 $1.bak
  mv /tmp/$1 $1
  sed -i -e 's/,NULL/,/g' $1
else
  echo "File $1 not found"
  exit 1
fi