# A bash script putting all heat consumption data in ?_??.xls files 
# into a single text one

for F in ?_??.xls
do 
 
xls2csv -g5 -q1 $F >tmp.csv

sed -r "/^,+0/d; s/^([1-9])\./0\1./; s/PDS *//; s/ +/ /g; s/ \"//g; s/ /_/g; s/,/ /g; s/\"//g; 
 s/^(..)\.(..)\.(0[5-8])\. /\3-\2-\1 /; 
 s/^(.)\.(.)\.(0[5-8])\. /\3-0\2-0\1 /; 
 s/^(.)\.(..)\.(0[5-8])\. /\3-\2-0\1 /; 
 s/^(..)\.(.)\.(0[5-8])\. /\3-0\2-\1 / 
 " tmp.csv >tmp.txt

nons2bla tmp.txt 32 09

cat tmp.txt >>allcons.txt

done