Convert a SQL text output to CSV, for when someone sends you SQL text output of a table instead of a CSV...

clean-mess.sh

#!/usr/bin/env sh

#
# clean-mess.sh - Convert a SQL text output to CSV, for when 
# someone sends you SQL text output of a table instead of a CSV...
#
# Beware, this will not properly handle double spaces in a column
# because that wasn't an issue for the data I received.
#
# In this case, it just does every .mess file in a folder called data
# but this could easily be made into a reusable function
#

for INFILE in $(ls data/*.mess); do
    OUTFILE="$INFILE.csv"

    echo "Processing $INFILE to $OUTFILE"
    
    # Sed string for the sed that comes with MacOS. I think you can use
    # \+ with other other versions
    cat $INFILE | sed 's/   */,/g' > $OUTFILE

done;