#  Fix the DBF files to eliminate excessive decimal places, very small or negative numbers
#  GW Only
dbcat -v GWOnlyExport.dbf |head -1 > GWOnlyExport.txt
dbcat GWOnlyExport.dbf |awk '{printf "%d %d %d %s %.2f %.2f\n",$1,$2,$3,$4,$5,$6}' | sed -e 's/ -0.00/ 0.00/g' >> GWOnlyExport.txt
#  GW Comingled
dbcat -v GWCoExport.dbf |head -1 > GWCoExport.txt
dbcat GWCoExport.dbf |awk '{printf "%d %d %d %s %.2f %.2f\n",$1,$2,$3,$4,$5,$6}' | sed -e 's/ -0.00/ 0.00/g' >> GWCoExport.txt
#  SW Only
dbcat -v SWOnlyExport.dbf |head -1 > SWOnlyExport.txt
dbcat SWOnlyExport.dbf |awk '{printf "%d %d %d %s %.2f %.2f %d\n",$1,$2,$3,$4,$5,$6,$7}' | sed -e 's/ -0.00/ 0.00/g' >> SWOnlyExport.txt
