#!/bin/csh -f

# Combine all grades-gmail.csv in teaching directories into a single
# courss-gmail.csv.  Entries with duplicate email addresses must be
# consolidated to show all a student's courses together or drop
# entries that are for altemail or grader when the same email address
# already appears as a primary email address.

echo "Name,Course,Email address"

grep -h -v "Name,Course,Email address" `ls -t ~/teaching/*/*/grades-gmail.csv` | sort -t, -k 3 -s | tee debug \
   | awk -F, 'BEGIN {prior[3]=""}\
              {addon=""}\
              $3==prior[3] {if ($1=="grader") addon=$1" "; prior[2]=prior[2]";"addon$2}\
              $3!=prior[3] {if (NR>1) {for (i=1;i<=NF;i++) printf prior[i]","; print ""}; for (i=1;i<=NF;i++) prior[i]=$i}\
              END {for (i=1;i<=NF;i++) printf prior[i]","}'