mikkun · August 29, 2015 14:03
diff --git a/csv2table.sh b/csv2table.sh
 #!/usr/bin/env bash

 echo '<!DOCTYPE html>'                >  out.html
 echo '<html><body><table border="1">' >> out.html

 cat in.csv                             |
 sed -e 's/^"""/"”/g' -e 's/,"""/,"”/g' |
 sed -e 's/"""$/”"/g' -e 's/""",/”",/g' |
 sed -e 's/""/”/g'                      |
 tr ' ' '\a'                            |
 tr ',' ' '                             |
 while read line ; do
    echo '<tr>' >> out.html

    echo "$line"                       |
    xargs -n 1 echo                    |
    sed 's/^\(.*\)$/\a\a<td>\1<\/td>/' |
    tr ' '  ','                        |
    tr '\a' ' '                        >> out.html

    echo '</tr>' >> out.html
 done

 echo '</table></body></html>' >> out.html

 exit 0
	#!/usr/bin/env bash

	echo '<!DOCTYPE html>' > out.html
	echo '<html><body><table border="1">' >> out.html

	cat in.csv \|
	sed -e 's/^"""/"”/g' -e 's/,"""/,"”/g' \|
	sed -e 's/"""$/”"/g' -e 's/""",/”",/g' \|
	sed -e 's/""/”/g' \|
	tr ' ' '\a' \|
	tr ',' ' ' \|
	while read line ; do
	echo '<tr>' >> out.html

	echo "$line" \|
	xargs -n 1 echo \|
	sed 's/^\(.*\)$/\a\a<td>\1<\/td>/' \|
	tr ' ' ',' \|
	tr '\a' ' ' >> out.html

	echo '</tr>' >> out.html
	done

	echo '</table></body></html>' >> out.html

	exit 0