dumpas400

for i in `cat filelist.txt`
do
     echo $i
     rngdbdump -cn subs61 $i > $i.csv
done
    
### Change percent sign to xyzpercent
grep -l \% *.csv > list.tmp
for z in `cat list.tmp`
do
     echo $z
     x=`basename $z .csv`
     sed "s/\%/xyzpercent/g" $z > $x.tmp
     mv $x.tmp $z
done



### Change date from mm/dd/yy to yyyymmdd
for x in `cat filelist.txt`
do
    if [ -s $x.csv ]
    then
       echo "Processing $x.csv" 
       awk -F, -f pattern.awk $x.csv > ${x}1.csv
       mv ${x}1.csv $x.csv
    else
       echo "$x.csv has zero bytes, discarding"
       rm $x.csv
    fi
done

### Change back to %
for i in `cat list.tmp`
do
     echo $i
     x=`basename $i .csv`
     sed "s/xyzpercent/\%/g" $i > $x.tmp
     ux2dos $x.tmp > $i 
done