rem PrepAlabama.btm
REM get Alabama city tax info and massage into standard CSV form
E:\
cd \com\mindprod\americantax
rename alabamacities.csv alabamacities.csv.old
rem csv file.
download http://www.ador.state.al.us/salestax/taxrates.txt alabamacities.csv
rem get rid of inactive entries
CSVSort alabamacities.csv  7s+
CSVAlign alabamacities.csv
echo delete all entries with an inactivate date.
echo make field list into a comment
pause
%EDIT alabamacities.csv
pause
rem extract just fields we need city, rate, countynumber, date,tax type, rate type
CSVreshape alabamacities.csv 1 8 2 6 3 4
rem should get rid of header and non-sales taxes .  Also get rid of lodging tax
rem keep only Sale Tox, general
Extract "ST,GENER" - alabamacities.csv >temp.csv
copy temp.csv alabamacites.csv
rem city, rate, county#, date, st, gener
rem Strip out ST and GENER
CSVreshape alabamacities.csv 0 1 2 3
rem city, rate, county#, date,
rem sort by date, so best at top
CSVSort alabamacities.csv 0s+ 3s-
CSVDeDup alabamacities.csv 1 3
rem city, rate, county#, date,
rem strip date
CSVReshape alabamacities.csv 0 1 2
rem city, rate, county#,
CSVSort alabamacities.csv 0s+ 2n+
CSVAlign alabamacities.csv
REM -30-