#!/bin/ksh

cat PlayerRegistration.html | tr '<' '!' | tr '>' '!' | awk -F! '/Club Reg/ {
   CLUB         = $13
}
/Richard Goodhand/ { GOTRG = 1 }
/(Premier|Division [1-9])/ {
   PREG         = $11
   PNAME        = $25
   PTEAM        = $33
   PDIV         = $41

   if ( PDIV ~ /remier/ ) PDNUM = 0
   else if ( PDIV ~ /1/ ) PDNUM = 1
   else if ( PDIV ~ /2/ ) PDNUM = 2
   else if ( PDIV ~ /3/ ) PDNUM = 3

   printf "%s,%s,%s,%s,%s,%d\n", PREG, PNAME, CLUB, PTEAM, PDIV, PDNUM
}' | sed 's/Chris Tilley/Chris Tilly/' | sed 's/Martin Chamerlain/Martin Chamberlain/' | sed 's/Eddie Broom/Ed Broom/' | sed 's/Keniv Gooding/Kevan Gooding/' | sed 's/Nichola Doy/Nicola Perrins/'

exit 0

# ---

}
END {
   if ( GOTRG != 1 )
      printf "579,Richard Goodhand,Phoenix,Phoenix Cobras,Premier,0\n"