log2csv

log2csv.sh

#!/bin/sh                                                                                                                                                                                                   
echo 'date,fsr1,fsr2,fsr3,fsr4,fsr5,fsr6,fsr7,fsr8,event' > 2014080${1}.csv
grep 'Preparing to post message: {' zigbee-gw2014080${1}.log | sed 's/[^{]*\({.*}\), to.*/\1/' | sed "s/'/\"/g" | sed 's/u"/"/g' | jq '"\(.date),\(.sample.R1),\(.sample.R2),\(.sample.R3),\(.sample.R4),\(\
.sample.R5),\(.sample.R6),\(.sample.R7),\(.sample.R8),\(.value)"' | sed 's/null//g' | sed 's/"//g' >> 2014080${1}.csv

run_me.sh

#!/bin/sh
./log2csv.sh 5
./log2csv.sh 6
./log2csv.sh 7

Uses jq for json parsing in shell. So install it!