TRIM5

!/bin/bash

export_zmemo.sh

DELIMITER="¬"
isql -S SERVER -U user -P pass -s"$DELIMITER" -b -w7500 <<EOF
SET NOCOUNT ON
GO
SELECT * FROM ZMemo
GO
EOF | \
awk -F"$DELIMITER" '{
for(i=1; i<=NF; i++) {
gsub(/^[ \t]+|[ \t]+$/, "", $i)
printf "%s%s", $i, (i<NF ? "'"$DELIMITER"'" : "\n")
}
}' | \
grep -v "^$DELIMITER*$"