Cassandra cqlsh query output to CSV

cassandra2csv.zsh

#!/bin/zsh

# Cassandra cqlsh output is pipe delimited, it is useful to directly pipe query results to CSV instead.

if [ -p /dev/stdin ]; then
	sed 's/\ //g; /^----.*/d; /^(/d; /^\s*$/d; s/|/,/g;'
else
	echo "No input on stdin."
fi

I've been using sed script in this zsh script for quick test queries for years. It has been so long that I don't remember if I wrote the regular expressions or borrowed them.