Messages posted by: hansley

I had the need, so just hacked this out and wanted to save others the pain. These two chained sed scripts will delete the header and footer rows, clean out the 1> bits, get rid of the line between the header and first data row, get rid of all extra whitespace, change pipes to ",", add " to the front of each line, and clean up ugly line endings. The only thing to change is to change ColHeadOne to whatever your first column header is. It dependes on your jisql output being named 'interim_results.csv'.

sed -e 's/^\x0D$//g' \
-e '/^$/d' \
-e '1,2d' \
-e '4d' \
-e '3s/^.*ColHeadOne/ColHeadOne/g' \
-e 'N;$!P;$!D;$d' < interim_results.csv | \
sed -e 's/ */ /g' \
-e 's/ *| */","/g' \
-e 's/^ */"/g' \
-e 's/,"*$//g' > final_results.csv

Enjoy. No warranties, expressed or implied. Your mileage may vary. No whales were harmed in the production of this script. Please recycle when done with it.
-Bill