rem propMoneyFacts.btm Propagate money facts to website
@echo propagate master country/money/population file
E:
cd \com\mindprod\repair
rem tidy master moneyfacts file
csvsort moneyfacts.csv 2s+ 0s+
copy moneyfacts.csv moneyfacts2.csv
rem  chop off flag and population
csvreshape moneyfacts2.csv  0 1 2 3 4 5
csvalign moneyfacts2.csv
copy moneyfacts2.csv E:\mindprod\jgloss\snippet\moneyfacts.csv
rem
rem spin off moneybycountrycode
copy moneyfacts.csv moneybycountrycode.csv
rem flag
csvreshape moneybycountrycode.csv 6 0 1 2 5 3 4
csvsort moneybycountrycode.csv 1s+ 2i+ 3s+ 4i+
csvdedup moneybycountrycode.csv
rem cols 2 3 4  already entified.
csvtotable moneybycountrycode.csv  alignedmiddle "" countrycode country currencycode currency behold decimal
copy /b donotedit2.htmlfrag + moneybycountrycode.htmlfrag E:\mindprod\jgloss\include\moneybycountrycode.htmlfrag
rem
rem spin off moneybycountryname
copy moneyfacts.csv moneybycountryname.csv
csvreshape moneybycountryname.csv 6 1 0 5 2 3 4
csvsort moneybycountryname.csv 1i+ 3i+
csvdedup moneybycountryname.csv
rem cols 1 3 5 already entified.
csvtotable moneybycountryname.csv alignedmiddle  "" country  countrycode currency currencycode  behold decimal
copy /b donotedit2.htmlfrag + moneybycountryname.htmlfrag E:\mindprod\jgloss\include\moneybycountryname.htmlfrag
rem
rem spin off moneybycurrcode
copy moneyfacts.csv moneybycurrcode.csv
csvreshape moneybycurrcode.csv 2 5 3 4 6 0 1
csvsort moneybycurrcode.csv 0s+ 1i+ 5s+
csvdedup moneybycurrcode.csv
rem already entified 1 2 5
csvtotable moneybycurrcode.csv alignedmiddle  currencycode currency behold decimal "" countrycode country
copy /b donotedit2.htmlfrag + moneybycurrcode.htmlfrag E:\mindprod\jgloss\include\moneybycurrcode.htmlfrag
rem
rem spin off moneybycurrname
copy moneyfacts.csv moneybycurrname.csv
csvreshape moneybycurrname.csv 5 2 3 4 6 1 0
csvsort moneybycurrname.csv 0i+ 5i+
csvdedup moneybycurrname.csv
rem already entified cols 0 2 6
csvtotable moneybycurrname.csv alignedmiddle  currency currencycode behold decimal "" country countrycode
copy /b donotedit2.htmlfrag  moneybycurrname.htmlfrag E:\mindprod\jgloss\include\moneybycurrname.htmlfrag
del moneybycountrycode.csv
del moneybycountrycode.htmlfrag
del moneybycountryname.csv
del moneybycountryname.htmlfrag
del moneybycurrcode.csv
del moneybycurrcode.htmlfrag
del moneybycurrname.csv
del moneybycurrname.htmlfrag
del moneyfacts2.csv
rem -30-