# Last edited on 2014-02-05 00:57:32 by stolfilocal # WEEKDAY ! Wed ! Thu ! Fri ! Sat ! Sun ! Mon ! Tue ! Wed ! Thu ! Fri ! Sat ! Sun ! Mon ! Tue ! Wed ! Thu ! Fri ! Sat ! Sun ! Mon ! Tue ! # EXCHANGE ! 01/15 ! 01/16 ! 01/17 ! 01/18 ! 01/19 ! 01/20 ! 01/21 ! 01/22 ! 01/23 ! 01/24 ! 01/25 ! 01/26 ! 01/27 ! 01/28 ! 01/29 ! 01/30 ! 01/31 ! 02/01 ! 02/02 ! 02/03 ! 02/04 ! # NON-CHINA | 38.69 | 26.46 | 56.09 | 23.56 | 32.71 | 35.73 | 24.50 | 40.25 | 21.86 | 50.95 | 33.04 | 44.80 | 73.62 | 63.76 | 25.50 | 41.61 | 21.58 | 25.31 | 15.11 | 18.40 | 21.72 | # CHINA | 119.22 | 95.73 | 111.04 | 70.68 | 95.84 | 96.22 | 59.93 | 43.31 | 44.18 | 130.08 | 87.53 | 128.26 | 102.97 | 151.70 | 63.19 | 49.82 | 33.54 | 51.55 | 48.48 | 44.56 | 32.75 | # TOTAL | 157.91 | 122.19 | 167.13 | 94.24 | 128.55 | 131.95 | 84.43 | 83.56 | 66.04 | 181.03 | 120.57 | 173.06 | 176.59 | 215.46 | 88.69 | 91.43 | 55.12 | 76.86 | 63.59 | 62.96 | 54.47 | WEEKDAY ! DATE ! NON-CHINA ! CHINA ! TOTAL ! Wed | 01/15 | 38.69 | 119.22 | 157.91 | Thu | 01/16 | 26.46 | 95.73 | 122.19 | Fri | 01/17 | 56.09 | 111.04 | 167.13 | Sat | 01/18 | 23.56 | 70.68 | 94.24 | Sun | 01/19 | 32.71 | 95.84 | 128.55 | Mon | 01/20 | 35.73 | 96.22 | 131.95 | Tue | 01/21 | 24.50 | 59.93 | 84.43 | Wed | 01/22 | 40.25 | 43.31 | 83.56 | Thu | 01/23 | 21.86 | 44.18 | 66.04 | Fri | 01/24 | 50.95 | 130.08 | 181.03 | Sat | 01/25 | 33.04 | 87.53 | 120.57 | Sun | 01/26 | 44.80 | 128.26 | 173.06 | Mon | 01/27 | 73.62 | 102.97 | 176.59 | Tue | 01/28 | 63.76 | 151.70 | 215.46 | Wed | 01/29 | 25.50 | 63.19 | 88.69 | Thu | 01/30 | 41.61 | 49.82 | 91.43 | Fri | 01/31 | 21.58 | 33.54 | 55.12 | Sat | 02/01 | 25.31 | 51.55 | 76.86 | Sun | 02/02 | 15.11 | 48.48 | 63.59 | Mon | 02/03 | 18.40 | 44.56 | 62.96 | Tue | 02/04 | 21.72 | 32.75 | 54.47 | # gawk 'BEGIN{n = 0; m = 0; split("",A); } //{ if (n == 0) { n = NF/2; } if (NF != 2*n) { printf "**BUG\n" > "/dev/stderr"; exit 1; } for (j = 0; j < n; j++) { A[m,j] = $(2*j+1); } m++; next; } END { for (j = 0; j < n; j++) { for(i = 0; i < m; i++) { printf "%s |", A[i,j]; } printf "\n"; } }'