Advertisement
Eardwulf

esc_sort.sh

May 16th, 2016
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 17.44 KB | None | 0 0
  1. #!/bin/sh
  2. #
  3. # base data: https://www.hypercomments.com/api/go?url=http%3A%2F%2Fwww.eurovision.tv%2Fupload%2Fvoting%2FESC-2016-grand_final-full_results.xls
  4. #
  5. # usage: ./esc_sort.sh Germany
  6. # or empty or some other country eg Russia ...
  7.  
  8.  
  9. csvfile="H4sIAL4aOlcAA319S5MmuXHkfX5FnXRKoyWAfB6plSjRVpTJOLuHPRZnyoa9albTanpII3+9PoS7
  10. RwQyv6Z1qafF8sxEAoiXRwTy15//8Pr+6XX657fPP3365U9TnaeyTXWZarW/16ks08v08t2vCfxf
  11. f3/74Y8vv3/78y9/+Pzph6mWqawdVptdWPtPxv+fP769/Ofb1z++fXx+ff/x5/7rxx0f6H73Yn+P
  12. D/j1398+/vD66f+/vk/lnMoDXuwpj5/W/5eM/fdf3n96/fjbdPTfnf3Gj79m+5mKo3779fXz36al
  13. /89t2qf6+Lv2S+ZA/Pzx+va5Ax6POzrUAPsDGQ/7518+Px72+MdjKG3a+iO3qUOW6XDQ9399+/Ht
  14. vU/F0Sdm63898Mdj2M1B//b28afX97/1Rz2e0ae89H8UuyS/328+Xt9/eJvs3ez/bDYewwzIf33p
  15. 89pffe8jetwMM7w9brTGpP7y89eP18998LjL4579X316a6zt3/788cvPtug2531ZZ1vZcU2/f6xQ
  16. v9Xj15vdYrWlOvv/m3H/8enrH3+xf/WlO2xku639/Bjty7TEkz++vH59/PexF/qdNpuLw8YwD7f8
  17. /S8///z4zz71913tv/1fe4ztz6+f3h9ztWIVl8m25pZH9fr1L/1RNozHeGzz9HGV4Un/978/Hnd6
  18. s9+sD5DtiDr1Bdoc9LvXz19f+yPK46/HsNfJRl/Tff7t7cvHT/15kI4t/YyLbWv0+O9mM27z+VjH
  19. YhttGNj7p69vP77870/vP/345SGxfZPN/LGJW/NNP/70Zgtg4vy4X7Pl7eN8mR4rz19L/Eu/2/n4
  20. v76zS5/dF8dcJL9PGgUFQveYnoS+yn3BZsMLYcdzvnlBkvu68qdvKf07YyX3fQ2riS0E45CgEQfJ
  21. 7w9tutdsq74Mt6P4998t2qRLVk2aJWmAxfbVav8tfRcGhgqgdpnHDoaUj/MtDdB3BPahyX5Hn8Mj
  22. qQFK+mOTvjuCCqCafuOw7a5dTXQtqPl1FYAVPh8D3LijY42hAUxT9r2y2p+t73i9H2T/lE4u3AW1
  23. DeNOog8diFW3LV3HhZfsU4vsFMc+HXUAUvbX/tv+p2zSiTGxEP9j2iGtlO6WRwbx70+ASVltY5r5
  24. yk+T/JuCroVWC8JttoM4qIA+VZiyrmyOrnp9qSn/6Y8tzjEuTR/TYfdvfGKt0pIa0ij5fbawbZo2
  25. OJWlL7XLtel8/4Mpc9RVso9+R9MWXRhCUfkFN+E2kSoFRtbeog0XJOGGwVtpGEs4DA526aZqq0to
  26. xBFJ+S70Wfom22hiLkBIONYHa1AWGtKYLIl3n6vdoOEpOCosPJYI9gGLNj7UzTzcGJjKPUuAQynm
  27. K4z4TuWydTF3jAR9lRitnL1yXR7ZcTO6m3bT7IYk3gXCfND82aPhi4y4kOYta75uxUt+riS5i91h
  28. w2zZNDiQklwXmd4KbUmnJcZn0txly365mdpap7x3Jc7d9YOdXri1xldwc24jOvnH1jehIMxdpBaJ
  29. 1wLjblY/LS2F2p0k0/N1dZMRW5/CjV3f90mjpaGtiiGO4n2aF2brsZq+W7oqiPsmy15ta82a8SRQ
  30. gw4ACOq/LFD8BF1VQLUnnva3KYOAXoX/pB0whVyGubqY9QZD2D0U+CN5mJJ6ugi7Nvo5rKULfTVP
  31. vb+tpDDv7sGnh4Gin9qG3Z2lfhN2p4uQdmPIfYNnOZsu6Wu4O8LlfWdkgx1Um4w/cS7sXb88AO0i
  32. S0nWZ/k/TR5RNz5xq9gO0u/9v2b6Wqwt1YENCJqA49uGmZBbb9aEEdqSrBBhg2nvf4oc0D5teU9R
  33. HRwmtCvW/YQvTogUQTGFsZjp7LNyxKBMBcC21e6WQB6yzkta4NBbmkWHUGaca4FVTkm7WHUCqQiK
  34. jEX/e00GI+sAGOA19k4dN+xFrndGyfApEBZluATbVOxB/8RMiIUVIU8u2Ka0qVkabfbLiL3KN8I6
  35. PAAh/3y95CrnC3UhzG0KxuMSyXCDRt8s3rYILaNotRvdXW7K4gKckJDhzcyOTe1hYrMN0yAB3i0W
  36. Wk2tt76hMkp+eVN0uUnQ6/Wp7pzPdEjdpa43rPzzCsMEW+cSE7gI0xeG8PDATU4DluJ0uCCHqZuu
  37. h+uwnPTTNwX8Vbpyv46QUg2ipsz6x+H6N6Ah2XyJ00RSIWV6PCXb3sB05UHK4HJHyncZ/8D9TEOE
  38. jNvwoKZ3++cKdZIGyNC9ynH3YOH2LpL06g6fyfFsQh4wBfDYNWYU+25bx/1AQV9SfLUw4rIQ67KA
  39. dOUPqlJqrNvkPHHnzYYujJTrTR6kGjwozj8d+1AJr31juGqY6Tn0HWTMVmCuTB4YAljxk6Yn3/Pm
  40. 9JtvAq82L7/wmchrssDFrAHcLgGlNWDyDxriRv9IKJr9Rt3FsXpQ4DCa/SJV2OR8b+MMSWsYfdEU
  41. D5oZfoiuYG71G0O8hk3vAFcWYCvcxno8IKA0xUm9ArmBh5lx0hQb/M6TfB68Kp9b1xOnOSHVYgYQ
  42. QLHAVBILjRNpgV1b0d+RGmKmVapFVO44slAP5q4bFSHPM22rCAKK0VwIVTAn+XZJN0BIQzf4yKQY
  43. VoURK4OoYVzUCiXFYiaecOAEk0ZYaE0w/K5pHAJt0J0BsCM2C2t6lFQBxbvIpXSHZFggsH5kZcX6
  44. lXEWrmzeYphVYcUqTtVvTBWwBpe2muv0MLXfSeyfUnWHmLq+CXBHA1/l2tzRBhXcTerCGTJwdueX
  45. 5G+JOntJN05xPDYAOAJs/wykaJvxLtgKzTcVEHIEDs51t019tRPGJZrmw2gYanNh5AWsScstiSwT
  46. zl35DSFLFXsZOs5wFOrF9+7mvocgkmezBv7g/gNX3mc2UfTkiIyG6CR2LCxFWlkD6IZBieA96cqD
  47. mpvFEG1JpA0XIr1T7D0PUcbFdLE+GXqdNMBhJQwnqV61DNA3rr4wPLJ0Zj9MUGEbhqGFVJ/kd+ua
  48. nFvh3NDPiMrWqcrGOIbe/EyrQXVUktBy1SndFb5ANecLyYpxneCgFXB+C7daizFdI/mTHCMN0jE8
  49. 1q26PHgEjbU//KVL9ZefH79++aeXf3/7+PvbT1/+8uk9RfULmSUsnbNBTy+66AVQlSB06myB2dPL
  50. bpb/IGkTP+XbDx0Teqs4oRUsc+mi8uwy5wOqMiFNP5TVZ1c5OcCIuZGW0ZQ/vcbpf2a0CmMECcvT
  51. +Y9cgHHog3Pz/BIpn0UM6KIQ4x/MXvYvFlmcwaF5dhX1EoIvMAzmBz5HS0WtMv1FhOE/mICReqgm
  52. dyBLuyA83X1UXo2E4xJ8/zefQkWGRGvh34fpzWfw5KJsFPOTrFz9B0+JeAak4JEM3zM8ldwBIn+H
  53. kenG5hsvATfG9pRpH+nObw5IfEYhCa6cmSzss2uc2+CCpFzRU7wrRWTOYETK4sb5+W5kKNRi+ai2
  54. /sFudGeo2LK0cIbooT19nUt0hPT2Qi8bxOu3nxhe0kzmaAkOxWVXStSicgaK7noIdHWmNhohF0Sp
  55. CV1wU5c7p3g1/dDfP8OzfrS4m3mFRnLGdJ3AKfN5kqeuEtthEKEIF3GlO122EefK72AmnHxTZywd
  56. paTHzKALltgushhNONdWi6o8vJCgjs9VOLSKkZyDyhiAUk6FhQg7tyw9Cp9FV0erLSQWFKm4WEoy
  57. oSVitXKS3+5i4q/LiMgUqDExYrYDk2hQJM3pOTlvEU8N1wnLYLxpiaBdwIiIZuzcxRzizdSdj82U
  58. yU6dsJF5R6o+Bgf9IYL8FNt32anuO8Fb87CaZKjjoCpOSgcY8BNeUaw8NMMGT+JACYwxti+XVQLH
  59. TD5bKgeMWYzsIv2KYUGFNnc4/MYU+EY5xn97dcJ3mn4Ju4pLUJ5TJRGC3ZOhuwhg+piBvUk6aUwz
  60. OxhzvnWWdIsq5klsAFdGSHd+ZO+rNvND2gSCiK/Ij+2sOSo24Q6BdDeLZg8UxIDQj2nxrKfHJtic
  61. s5SPkEkJGJ2kLQ/hEcpDpyWyFrDAVFECUgNUZ0R3J1cECS6kKMXG7H/fLD6tLvoLHdpCqXnIvi8r
  62. RB9jnj1XXRAL+ysybqoA7CwpQ42BQJkmJYsjz4xOhpAS6JPrZ3JtCxlPNHEOR1qZf1phf6YXLa2I
  63. rY6UqBXIxRkMolxnT24IB3Heo7yIKZ9xD15ynJ4PWiV8w/yDQPJ0LmIC6Ggf3kWm/Y6eubiIizKc
  64. q1W/Ncii7eEHCOvpYdDGMBG2rnqaj7h7/gMJDDijxd8d6FvRonIlMQtzxifBpuozJ4EZXIe5VJ+g
  65. 61bza5HYJSQqGmbqOqXz4jYU6h3h84J07mrWSbPipYrKtJLA2MU6ECiRbiTdN5V1UfKBkkiL2WSW
  66. a5ZRJ0wmfTEGDVUC/a6bAFGqxH2kH3gbmswUWDQqc1aCrD5uyOlKK+OivOXxJAt9UOxVWQS3RXuD
  67. +62J+fBUCQw5YU9yGWQ/fVSQ5ULvbKGASVw4KkryzFCYe7oMG9AluU4eJJ5J1wIFOT6MA97hLFgN
  68. RaxbZCiryKDC6DhvX1llUSNICUI88qguAlxZQQmCKYrXdFtPZDI2rk6OXcTRpbipKA31HDOkZwTf
  69. hJN5xg350v1+RSYtZ2UidrJd1FHjFZLUxcz+lkPbCxICKzN+qIaLgnHBMjexSIia5m17Bg/LXJC9
  70. 8Xo7hE0XuGQ5/UHEcwUmJ50pAU8jns/G4WRCabbJlvCGL0gJuPv9lU/gtr0siwt6UwXrGnkY0z/j
  71. BXLfa5A6J6urngxbTvwqn0bFD9rUI3xIfrKQ/ADf3O5o6YzVNjQVlemVK1JqQ9VBofdolC+jBlcw
  72. qwQyzcuzQTtP4HtjVxnLHe0MwTlkMeviVmHEkyGorl5WZlXuO0rO/ykvYE1e+rN1//RKDmslOaqk
  73. +XXMF52zQm02pChYmnR9gByHXTRbofrsK3989y9v7396/fhvVzssVziY5jsS5Oo37Ek3noyE+ysK
  74. f1dOKNPbjGNAqbqwl9Kohdme0lgrnu/rrsMmJT5HxjYDo+RZwR/13TLCPE1qzqmV0nrpus9PVFYg
  75. Lb0jRVNsDwhFvbPSGFgTxU7uyUGppgIZQbl9VDnCUddsYm7pYMNBEEhqpmiFD9J90Is+vzmjsrnJ
  76. VhWALzG1CqYgrN8xDCy0yaqCC+W/MmxseUDdns0X6EF/pigBc26aUmRVNJpwVB4gKwp5w0ZJ8aF5
  77. CFHMFB6qo8jj8gIp+L2LGKw2PC9ypFXlEF5OJgy1wknHq4UHkO+UiiZKpOyjoWNYpE+vTDZuXE7s
  78. o24CfGSjHjhggeqKEm/oaL9nBA4LHC2ULVEd/evPX78MTQ+Nj1ThBfekcE/Lo1cFEJ4BE/yqAg4K
  79. fmkTVUFgMyOwUN+zZeDUDhQ2RQ+VzTbMVIyvRQ0we/H0yUr3AUTab43K1aLalmGO3AeZRSDuilCX
  80. AanshjqLknssiCuBwtw2yww8bhZQkcQ+ac+vqNp9XOggaYFKTrVKo2Dj+BRnLwOJip15/4cM+Roz
  81. N1F9YTfbWctj4/sbUgVszNIzebxJaIXLSVXLu5/mQ5oOiAdKAxS5J3x0HadV7oN3zZiuQ0V1V7A+
  82. OCiBhe09iOGwaMPYoAeQDjpSEasAkUWAOayodH2AHeJVEngrUVk1PSbnCbDGU66SGNbG9BuzTo07
  83. Ek65j2mU/VVFPTPDP3BeftNEG1RSMwep+v7w3/zq//3q9796+d3rD28/jnrghLJm+QPi8hv6Wjal
  84. VGZRpw/Vwe3Cq15gsXqliJ42gberspNQyPFV1dvCy7tdkwsvFmaeRVU9HVqwDrtaXQo7q7oo3fEe
  85. yFifGNWaOXPP5jcqrBduprDCN3RiGSHOUe73dOypmbKKB6Wxac+viJrN4inIrEhvF0jTMK4/mGmH
  86. U3JfMVc4O+vF6FQ+VMl9N+VWjdzxRrm9Tw+UUHM+2ujOPp47NmVDF1QyoU/RTct9OJ4INadlzxWR
  87. N7ATIqeaO0/yzw9lcR84AptG7b+BIaE3cB+6d2mt3IhbtHLd0OG2FEtPVPu7b8o7Ftorumia2jK+
  88. sfi5f3NOyt/V/vMNgDhyVqZDhcFPL7jHOHWjqKvL6PmDpOnUhVs3NCQi3P7Np3fbt67fDtFAJ1la
  89. bTICr44OxRuWsIKDFPZeHV7ZdhcpVGHHQId2vzD1RnsnrOuuIhpBhXCaPQKpszbSBY10KSIYB1FR
  90. VRHHBWXse8K4eoIm2FlyudLLFsz9G/ROb8m/EcRVUVN+ceZ0yyYQGP6NmVcTGjTOdR1BkJIfs7zX
  91. 6qLToxyf3OTfNHCbYdV9Zb0FhHUR2sPS8HpJujiVrj23++J7nbjQLPAbkTT00NAfm5wc9cihkFNy
  92. T6D6QJTTPEhmUJdodOoFUXYDGeEyTi5VRyo/XXE8gGlrgqQxDugX9enTqRJKns5h4Rua6RqMnC+5
  93. U6yFlcQ19/EOq2TKcoGvZFJlXFqM6VIKOpPdWlW7V8ZbJj9HNWNKyRkOm2zMkMBnWoNuIeoJz5GY
  94. g+LFu4Q/42BLYaURO6IJzcJfVce1sptkzjdNoo8sBPd9+C3AUfItHACUgw0ExP6UCqGuA+uveZHY
  95. Nxs0giWlGYhJvgh2QPUORCISl7qDOCSxPKxBtG4y3Fmo06ioOVMpj7loJj1k1EJFUfcmvnRjXJ+e
  96. mI5oKOmhofIBS3TFKT6/qG/9zMgsygcTRWeKVwgLtrMwuc2sZ+kbnWNj9eeKJLKY9a6GOKo4oWGR
  97. lRBNkp7loUqFE+3NLWRWCZMQG3vF2i6b+VhDyvCsRKfPV8nPkwzDyJ1mCMAWakDXOIVm/xBduA23
  98. k/yqlQUdl0w2a1DRvQlf0gIGEOSOuQrvqnSYSiYoZ8LfGQqaq8Wj7QzPJMWmDMpJqgI7WNDUyqGq
  99. HhhDaF/BPGnC5EBRIUh+rGw3qZ5S1FTcEij4iUUkqhYP0i6gN3IUSHuyVoLkfm01stdUJCBcYics
  100. Dw+SD801woTEn4qrVEn8ULo+s0niK9yJ5q5ALK8fygD/hFXauzwif0XKfFEj/KyqwTbgcje3pdsa
  101. e6s7P+EPDYYSi4lVtIA1bhX9m0WbCJIKw+0jAzlh1hrrw9r1bRwY5B7FSDl/LEA0dbE2PjlhwtC/
  102. nycl7FnLe9nTqlmoysaUiCAz8F6IZOF6U6XPuARJpkVlslgQjoW2mB+3pA4tEimr3QuYJ/1ZOanm
  103. 7TnCPzlxZcNuX5zKEvZy2IrqNYZKWWFzIXaj78b9dw5A7+vcSbmU0OyOUUFSSlMiMIq58eKFRQcj
  104. NcqkpAdAT3gu3uUH2XEEJdX126Hhj2+YWjSWaAwBI4OtxVlLR6g0i4ujw8RXjZ62d26r2IHkgg+e
  105. wrpFtb+nTTMuWehVlR7USiu1Eh/sGUl2uhcli+pwQ4lsS8msNRGKPkBPRG5IhnI5xrtFlwbai/aI
  106. wQSJ4HydlotYA0GRVWEN56GFzAImIdMRXm1iX9PLuELwZqIya0b2CnaKY7oXF6uzDHbTLSbvS7k+
  107. dRIJyxBp1j7e3rKnfUaZM1k67jfg7gzils44ORRrEf0ko+g1DEfqJiE8G2uoFhQjzmw5Ei5VGC70
  108. yg9vXyCGAl1lVheSuCU/UGba9++sErDhpUOqG/rQFqYnuTBASaQPBT6FVIhcEsDy8Uk1CZrXYhMX
  109. 8l+Ul1xRKSJE8szVeYfCXHoPnNQk+Kv2HdiR1VcVgr+w9KlEp4LezXuy2KlYo8M8jTmRdk2G3A8F
  110. mod9lA5NW6Xc1iw4wF0Kl5ZsNDk0b1DYtX4ltVVrZHFykjxaHmMwbFjJu8oKN2iQ7pZvwqig+ISF
  111. 2HAowpJXWLJuZdA7GWZ0Y+ZVIWvACiPpxs5paDiXqLogUXySYajDZo6+AdSQJ5sigcknJVZURCzJ
  112. exXsIuQ7wo9anC5N2KuIbxOL8Y4JOr86NIn3ytAXRwQYnxC3pOgqKU+W04M6h3ka0IojkGLetCP9
  113. ld3JbippU/kfLLKAFN8DgYF5szr/QRB3spWaPOXYtuGZUUwIRFXMwdUVLtUUNllaEwN4oD5vydM+
  114. vEGGmW1fM29QYjWNygXBuPlbUpAVv7Bszo+LEy6ZbrK5SliBxvbHRse0SgHZW1uG+0mOKyPdg0qU
  115. XooPjycgFsZzLcpDfWS02vg14mKTn4B4cH0gPttUQgovQTCdflZR6r+nIvlYcXZVytFYOL10TIYl
  116. GlxyxhJIBvrAbvK80Vhwi6zjXeWRF5T5uPeE+ojf/vA2cuSs/IaBZU2Qoy5CfZp4coorDlQS9N5V
  117. HU29TE0IOsbX9EKKinGx3YV1s33Iu2iTerde0uPZ/qO++UquhULmqLDdC16hqAEww0L+Kx+1y3+s
  118. AzB55Kgx2aOBRZjEmCkLgCipjmOLqsMFDC1V4UMQBaHsL2KWN5gIyoNP79CoiDZF1+q+shT9k/Ea
  119. qgrctPkLkh9X+WaZRaivAy6JvjxsnruiIMYfTOFXHbOpywplLowffAi+ySgQ8Ps+LhhwuBZi7Wd5
  120. TT4qLz1mpdnBlBb1vXAu+wWURfVTY8Z9ofpj9R03bLIlQVL2DLKJLR2FJsMqQQmeYuW95MMHdusg
  121. YKCjFgw6SH5TdVYXdTnogAg6zb/9uIg/24dWEss1Ye5HpGE9T++wyui7/DfIxRZRi7AXBbCRWGCK
  122. bB1GmhRA0RlpDDVGoLqDKiqgdhTLbxlB40+zz5JKElk+M+63z05LO00ukHJjVZmF4MkFcbHfVOkk
  123. wlZr9jHIvc6g2EHcswNCoHToaWWEwGocyv7HTfYxpeAQdYyvL61Lv871YCnBPgzNzz495YscTDJl
  124. VJJ9RS+bdiiMpz82HZVyajYq3yTf0vuN6ZZXSi98HB+eMuwwC/Domgvtx6AEFOUU1udZFYGDUmOg
  125. 2bXCo6ypuz6y/O9RfUX1eQ4PTPS6Dvc5k/kflgqyukUwBwtmFvDjqQ7YwDYVpHe7LmpxS9n+RX1V
  126. 65jspwQMpx+D2V+ZiBTkKvwewPrRvUu+442L2yLiqzpdMuGzBiiIl2i7VftKYE6Pq7rn5BDS/bwG
  127. 8EC04/5sfuuo7oV62LxCmQiZ80Wlm5XaRnIBmLv0qDw7E7RmnEv2yUJrj5AJoFQfkdeFBeau41Sl
  128. fDfqPY6kkLhacZC5skdUlsOAkjU/2MhdxLIm2NBHpAoxr8cLnMfjtJYsh4CzT4ybcsRlO9lIqS2O
  129. ywR5gwdapAkX6GWOCVIMT8BG5PVXREQhn5we74glwply9nx59+86ri7FV1Vnyh9Lb6dlIRlRIuq0
  130. wvrOpGhUN+KtirrgcRjHcNfg06v7+eISsMldeFcv4PNqPLuToa6cm+qtUFsWsRvQN/EFbykqgi6O
  131. Qcf0NvOPnnJt6aaj6NLKt+ymGcyPOjonnYeE1LXeN5WrrOm4noVMGlBx1sii+nMnZoFIgXhRqyiY
  132. JO1+g+UDyCFo4r3w+ziptCSmO7hzzlIS2oMVsZ5/4wrFkYaql/PEMd/Jzycl/SC+nPrBQElYd+Y0
  133. C6uYqEjxND+bFBVppdLkS2UZSlz5OrUIeMLuYlQmrKZkVZMgxxEDihadOjkt3TxgM1Bw5PiyAY9D
  134. m005GoLCioxRYy3KDIHnejpjtk1sG/T4NRaBxMXKGieGMfml711+xVXExokKtEvooaMhFrkBsNt8
  135. f6fNVlYgep8S7kbYUyebwcee+i0Iv9fUos63+BkELcAjNQ4vy60VtBSRuf3+VKPHmjJHxNHMKiVL
  136. s3XKuAsFiT5EKZUpVUxrelKIfcIR8aa4mERPYiPjdXgcyN+7k+35pBqcWBqRhPrQu82cCPqKhKVT
  137. iNW3Jqqg82Ga1lTvurmBUMeL1jWotUMJjMakS3pifF2AhFRtLKlKoJy/1smBHtDrecNxZee0Rlyf
  138. 7kT5XsAcL1ONYloNSGX1pvsrWyrp/xAzZqVHgp0Q9swsNkW7MyhL3CR124M0RSkOdFaeaTBp4f+Z
  139. voQG1Hhu5aTMb6nPpQ6r7BLsqZmC2ei6OeZaArzzHRZkl9cBdBFfecY0UbtLr1/w7PNAWzDC0fgY
  140. l4y+sifOzuQ9BDidl4P9NDvcJtaBnrw+qHE2Vi2O96MsY3+jhK+c15lKFrqqtdDPAgicbHTEQ2UL
  141. Ox64fBihHGOYEy2kQ4M1h65aqUNQWRo4SvaGmQCDoqOV00xfjiTE9ubBGmnRo7i06NiPhbZ3HJ4s
  142. +C6qSgew1Os8u/x6AYV3yLULNIx0/NTIAKSn+zHDB8t8VSkz3tB7ZPQNlFAKjklJLlfH/FREgLx/
  143. llFik7dfL0+Mb4Qsk05DZYPSZTWo0lqytM4Rp9HdOPKiQ+1L/qpSurmUALiiMns2ousovEiuJG0q
  144. aZKv/+Kwe7scq8ZmdWcsCX1ztZuqhRUjwTIDPXbyn6TIWCHWGR3AUqtccZfgjM55oMSQLVxmGVP+
  145. Nn8/4GBigAsZU+LsGD3APSwREIqhi2qfqsKdkmYhn5vl3oQKcwLmEfRuYe/i6UH8OiWzi1JIC0nX
  146. uElOZhsXs8NXsuhQa+jtcOrW8eQrX8vrS7kF12ixj0clZ3xh9S+0XZPU8XGKnFWEVb1gfE0wSnpT
  147. PTbG1m2zRsXUl0imOfwsDsgPEI+wt/It4jlu0JvSiY3RDeys1ox5LT/K0Gv0b9P9iTQZPMChbJ2P
  148. vH7Uq1AZFCWrdDsKKg4d2KYWDQ2/+/L5xy9/Sa52hQvMze8MsXD3U4IrP+hQSTFm9LNDQIuSoHNi
  149. qnXBeO4nMg5eZwHdLGj+9ofUCntEynBPiOwhJu3yYRtHqfw7im/XFNj6POXa0ZLKR1XXIyBleJlO
  150. r01kUbYQqb2djROqV6ZHIqAOvSKjQ3nXKSRCRYM72/w3yjItqk/xYKBRIuxcmC+zB9bQYXvmAvwV
  151. 47AMFeRmUyVYdr3FTxWvLvQnpi96YeIRzLNfUTAX5wZJXcLQ+rBgsiuN8RZkiI8oilI2Ne+r7Ksb
  152. ReGyky5PRk66MH4u1qzqLq83joWObrBGRpH7ut2X5pP39+5BdVGHaFwXZ33mGR46vYGW2m/rBSo8
  153. AgyMzNrN1pf3r2/vbz99fMkaYCX3u0Y4nID3sy0Z7y5jbiNd8kQP4PgF36zteslwPJZ3c9bUqpbA
  154. cfTOHpVW4PUTKkrTPDJfo746A/2gC5WAqtHhMsh0fLjzYXYVcs4JKb/dW5Zlrl2/OjSd3hvNH2sq
  155. VEvYOBET9bqbt05kFFXDCXqHtgH52cukh26YwYfga04FYWfeBJ792ug4LOKwRiCVxA5XgB/0QXY/
  156. oVIBm/udlYWu0qvxbKkKte5v9BOkEB2ZtcXocOcReri+JZLJCZk8StcbjE+ls8ttYaJXTH0audE1
  157. AYOj82iJtc3Dloh0WFNpnwq7r4IjJbLgeBKYgjj0JQ/y4kA0cmvhrN82Zwr8TfO2ST7uy3f/+eXj
  158. r69BrpvUwAtWYpeIJ4Sd2rdUvvkS97t3je5o152DDiZ0PBrjUKW0qkvTTT3G3yRbLpB7xukzA2CM
  159. NhRI2fII4OUwypmtSAi3NCPh8Vf2vk86Z5aQOFRvkypZGEk9VB1Bmaqbw12IE3GIk1ZQvO8aGuaN
  160. KGqFlpuJrOC1L6fPaDoi10hkBa4Wrmg9/Ywtr6er0tVpWPIXFnUCLWMVD2HZXygoBazpRE09M4J9
  161. /jT2Pg/PjNM0iyS7kIJ6qAoNjMfjwlnzb1nEiMJfWKMty4LIHmYSJZHXeUDnhA/i9RMhCGFwv5G0
  162. iX7lJY8595YtDAHPVMqbl4Yakye0VtceAbs7C+7jKwTLN01fC9rUR73RbnUcd43H9YUOuDMjS4Zd
  163. JH3liTqsMmdSjNgnHwhVTzV6ECmZhI+yzrla5E/MGZrOtoDBUkcxdgFRTsyfKuKsaX4E8l6UGTWh
  164. B3qG9jQ1ico7ULy5eVaFmKhZXyZPq3gVGkFJ3A9ulJLbPQiTtDc28yK6VauHZisVtMEzrgyDH+pF
  165. i+UZcG47ncZLvaGx+6d/sNz822M5wkKMmf9cKcagNPXMFMXrSCg/jCPdLeSY9UbgemFONTA5/vYL
  166. gzoDoUF5n3dlAUvxbhxCcg48/THdQ4iLcdVBIyeHnkbsof4Ka4VOZ9NS46pAJaoiELMPl1Qjulav
  167. VNo9nkZRB7HwWJ+k5QqpgxfFaUy+PkzIogwp7kXYk0OsdNbRQtI2oe8dopnHd5kkOrNy6stBgvfh
  168. zwmU28hW5ZtTJS5hNNLzJCtQqZfS81S45gZKXZ/UKpqZ1HISNZg5z0Vg1LnAcKp2cpjnXOUi54p8
  169. 1XAz/7rnCZHcPHwhIJ3rIIoL0gluUnMaQr6Iz0KDVf8ekBZVPSferj97wb3eLYrV/Zz9lnovCRuK
  170. 1ryQa0v9RXpkqlkTj8mi4WGNoqXkhO2nnK/DUyXCxgoypkXDIBGpEC2M7Joq/YijGEPxQinCpsfy
  171. QYRP9Urskb/KU079VVKj7UnVpCFdRdjMB91i6xXwG6ZD6Qs7gqR+vn99f/ndY3e+p2h9U8056S8I
  172. WUJeq1iojnZxq8v1gifBOlslWVy5jPjLSS2zeljlvVxu7zI9s0JQCSVzPTNSHd/s2rUj9ZG4GFB+
  173. XAsPUlAXPkUsT5oL90YvtHG94MglaOTZouVqRUl818wJmc6up55IifTLAKK3jF+JI2VzW4Mg8/w8
  174. ig0n9fRwIE9+9s8bZxyhA1RD3gmS/C1CLm/zyO8ePP2u2ls1zV3GOXwLbBM7WdDY0fd/fnyk15c4
  175. emRVtJeQys4h3a08uoUnwzhZ8oZZIq/ISCiPkfy9shqn3JHu+yVcpOeaQr1nkseAvfK8CiRCWLA3
  176. bAuaf1Ju/DAHztq+LiDtzcz4paY6wTzAiydPjq7gAwHmaI63jiNtdzr0LQgVrrIrEi8dqSB8uH2A
  177. enLUyxnVehHBEP7ElV/V87LR8Rb2VsaKrhw6hCXf1v34OawoJRSKnbg4z1adOWdKngikChvjXZbc
  178. EKepSV/5BqFYQDAufWMDE1XsLJtR3Qt9ZsLy8dlNykTsURpUfPAzktiNw08wJ/QQn5wR1yZQrp/b
  179. WFgKlmLzZfWUndc4FH4y2fQhUFnIDxaaNaL8TkHfVy8LLUFdEyY3vtGBLcoamKT5pJpgLyICvd98
  180. 2GMKymmRi9rgpACAyt68TKrti10IEXDNs+isQ4u18+OaTL+vOsxmv832Jz+zWx2FmIY8oOt5LwvL
  181. FE7Ub9d0y+hE2ZGHXrzb+vvPX/7yNpbYNPEyTX15Drr6AP45qkMl5tTBuuBZ4q5NPMGQC5Lx4yc+
  182. w7fWyYTDzYOtF4ta2JjYMszbUWEjeC+vXAgcHYCTG2DNpXIxT564I2Opsv05z6bEuShxP3MA1IbC
  183. ZY5eZ/yhvU7yLKS79qsMak1EucNS2ZzKGCpqk016fJ4zQW8VX3hj+256Wm/I9UYzuzM/sY/PjA/X
  184. wBVFu7QlKgM0dqYwI7JQ7IbbpXMg3QtpbMLpClM46QCv/Nzk3UGH+/B0AAxZb5UnMLaIEVIRmDO9
  185. TOw93TMkV97gvOvQAsJ4uR0LZUrUJA2Pkzo4WCO1yvEpIy4bds/6FNbfdhXsg7uw8OK6mK92jj/u
  186. HEc48ujuLcg0zNrw3Sq3p96MB9ATo96YpoAT1xL4fqQENHdFMq/QATLs5fi2qqjppKkmLEcCEz4Y
  187. oEo+QTwEmE2ot0nfs+Kv/binRQLr2ZuYC/f6dfCA58Ama60CzBP2KnBm7RO1jWEuh1F785V3twBG
  188. mW+IixsoOfmvhkgfvfCevcZIsOsZTGMIe/FUdkPmXEvoJ8cwKVWRfpapxJv5sTEqgigyTwFKGThR
  189. 9yW+Ypw2TfownUJ9r+wKmIQcX9cqSNLTc8Lz/GtzqZwmmAOA3Ho3ukRFbXsMhAwFyYUFXeETV6SF
  190. tGp+BkwbWDYFyzHbESeoGLHqzF6O6FYnu0PDUpHlKY1cWVXpgNq4udkkpqwcoGENRw6oi5xuKqBA
  191. Fh3H2BP6pLZ9VmW4knCEZr+7Mj1qH61ZKICA5d7RJZ3jcfiWB87Zc2hNputnUUZCkYUrqtg9J9V7
  192. JFRI7AnPx0iHopJlonL9zCreWB0e6W7+zTgkd8xBwsnKBIznuazR9yeLxAlLhTPrjRrWWkVda42y
  193. repsJGEhkiyDSnV+CTZ+GYJN09WbmfTM6EtZya7tjNjTvSiRiFe9crfLI4ekSlfGQxEQdvXH8dDU
  194. LszOe8drGWY8mVsd+QcrSKkFCmKLQsoDERaq0mOB/UB4msNFP3N+XPocBGifdUp1mxrT3cqWOLkn
  195. 0v26Zz4Cgie/eGnr93/99PXvELHkf5cJn1WsMhsD7uqCF+pqJ+60P+KSJ8LMcoeiiurLFZfyuebV
  196. rpCR6wNSCR1SClUF0y61AYaA83j/gq8em1UbURDwBa4BTFZlNJJnLdHsltl1y91guRNWTHtlbhME
  197. RYk9F9DMt1tKpTH9QBc0QdOBjDu1bqUvY6Fvgg6foGPnXzbWeQFSnayKBqIac9gPkWyrUbocTb7D
  198. DFBbHNSGs0wv/ZcETWYcftypMGu/bkhl3hrZSD+gvNx3SjSTb5LmGiWIw1ihRnxJ2S9OG5pH6gdL
  199. 4MMSSKjOtGaBcx9gZuRtQoYDuTJuSMo1McFeTDJuEy/I23QSwJLJmOuKms4v7GuvUUE8jHNUMKc7
  200. YpgsV8bp1orvK4Pbg/wFLetV/nPOnTWbNnEWytzQV4VD2lc1ENQ316suXkFl0gryDNm8XjK2y5DP
  201. UYL22TOgSdBBXlBzUe2E8jvS6+mdn/O9fJud1A23U/3tJGm7B3/Fxyeo0IAZbMAVKa2iduOqVCRF
  202. 9YoP1XJIV/Pg7hs0PlZbPW2xJtfjtjzJBxFh5d01tx3g/XPwiVZl69enw060/6Z2Ah2C8Aw/1OxB
  203. 6A5lxOvTK+KjmXAyCw9fq88HpDTADC3SGCFAQd9GzzJ+MZjMt35j6DrLinyMir2/IXjpC1dVVVUo
  204. X35Yvys4eAQVQw9R/H1zMU9w6rCbTUWF23MJpULasAXQ0WkM0H3cF59HXfNVRzOWbyiB1J87T35a
  205. jRVPfqfJkDZanVdVSuTFMU8OmV7lPR6JNBH+2REYmx9lEFpU+KGIgMefl4i1BZOGOmlEdnh0OHxH
  206. IC8iYKXNxm3NPeEwFQCtEz4huuqIHJ+YxDecZBBX1oc/tItgcU48Ti862L31UFWC5CMrZZ8GB1jA
  207. dPCdf/pGIpBx0cJXkTdINak+p0NrrteLQ3/5wvonaIYWOieY/CWjea+l8xq8slS44di7Saee8ag9
  208. f6g8llUkmaoH6/iaccI0MlNeRUeHyUcnX4WbS9VH5TI49fbBoV28dlMAivyhEqaqo37O4T7BHLL5
  209. rKzeQDnMvqsDsiJbygAJeJXtRYH5rIbpNopKOhVjnvywThXTX27nrsZCf3+mz82JHtFP6nn3SMXH
  210. mS6Xy54eKQ+HUfL+5KrLMdRNrWv58IzLJZFwKH7um6zcE7i39aI52IMiCd0Fre7eFc4Megt382Ov
  211. szqci2Vd2+eEY6GPKzYO40DeaRWxAm/mgk7H0EeH55K4kAveP5mp3s0StdQXaHJRCm0GjAg8lOvq
  212. DEnHDSy77NN129A/Ae9b4N1ZtdJtMtTiDxRLm1DQc8WO2crSvGYQbvJ1DKn+kCXlG8usyv3eySPZ
  213. 3A0v7bkMUbtITblBAYl1HbU3GZ6TlFHRicIXbDpqD3/WaOC6QEMzNexKka1P9kQ0FKfIFXrn6Soz
  214. dlxlzVty+a/4+OwM6pQX1eWD7vofJmaHblKoAAA="
  215.  
  216. # format: From country,To country,Jury A,Jury B,Jury C,Jury D,Jury E,Jury Rank,Televote Rank,Jury Points,Televote Points # field sep:,
  217. #csv=`cat esc-2016_gf_fr-nix.csv`
  218.  
  219. csv=`echo "${csvfile}" | base64 -d | gunzip`
  220.  
  221. # cat esc-2016_gf_fr-nix.csv | gzip | base64 | base64 -d | gunzip # compress option for inline csv (ratio 1:3)
  222.  
  223. line="-------------- --- -- - - "
  224. getUniqCountry() {
  225.  countryList=`echo "${csv}" | awk -F , '{print $1","}' | sort -u | tr -d '\n'`
  226. }
  227.  
  228. rankingJT() {
  229.  echo "${line}"
  230.  echo "Ranking per Jury- and Tele-votes (j:t) - sort by j"
  231.  echo "${line}"
  232.  oIFS=${IFS}
  233.  IFS=','
  234.  for c in ${countryList}; do
  235.   echo "${csv}" | awk -F , -v c=${c} 'BEGIN {jcount=0;tcount=0;} {if ($2==c) {jcount+=$10; tcount+=$11}} END {if (jcount!=0 && tcount!=0){print jcount":"tcount" "c}}'
  236.  done | sort -n | tac
  237.  IFS=${oIFS}
  238. }
  239.  
  240. singleVotesPerCountry() {
  241.  # in $1 country
  242.  echo "${line}"
  243.  echo "${1} Ranking per country per Jury- and Tele-votes (j:t) - sort by j"
  244.  echo "${line}"
  245.  oIFS=${IFS}
  246.  IFS=','
  247.  for c in ${countryList}; do
  248.   if [ "${1}" = "${c}" ]; then
  249.    echo "${csv}" | awk -F , -v c=${c} 'BEGIN {jcount=0;tcount=0;} {jsc=0; tsc=0; if ($2==c) {jcount+=$10; tcount+=$11;
  250.    jsc=$10; tsc=$11;
  251.    if (jsc==" ") jsc=0;
  252.    if (tsc==" ") tsc=0;
  253.   if (jsc!=0 || tsc!=0) {
  254.    print  jsc":"tsc " "$1
  255.   }
  256. }
  257. } END {if (jcount!=0 && tcount!=0){print jcount":"tcount" * for "c" * "}}'
  258.   fi
  259.  done | sort -n | tac
  260.  IFS=${oIFS}
  261. }
  262.  
  263. getUniqCountry
  264.  
  265. if [ "${1}" != "" ]; then
  266.  singleVotesPerCountry "${1}"
  267. fi
  268.  
  269. rankingJT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement