filter table tennis results

# go to https://tttv.click-tt.de
# login with mail address
# switch to tab "Downloads"
# download "Vereinsspielplan (csv)"

original_results_file=Vereinsspielplan_*.csv

converted_results=results_converted.csv
filtered_results=results_filtered.csv

# convert/fix character encoding
iconv -f ISO-8859-1 -t UTF-8 ${original_results_file} --output="${converted_results}"

# filter output to necessary lines
awk --field-separator=';' '{print $1 ";" $8 ";" $21 ";" $27 ";" $28 ":" $29}' "${converted_results}" | grep --invert-match '0:0' > "${filtered_results}"
cat "${filtered_results}" | column --table --separator=';' # print result

# create file with subsets for each "Staffel"
cat "${filtered_results}" | grep 'Bezirksliga Ost'          > "bezirksliga_ost_${filtered_results}"
cat "${filtered_results}" | grep 'Kreisliga'                > "kreisliga_ost_${filtered_results}"
cat "${filtered_results}" | grep 'Jugendbezirksliga Ost'    > "jugendbezirksliga_ost_${filtered_results}"
cat "${filtered_results}" | grep 'Jugendkreisliga'          > "jugendkreisliga_${filtered_results}"
cat "${filtered_results}" | grep 'Kreisligapokal Unterland' > "kreisligapokal_unterland_${filtered_results}"