This parses MS Teams meeting attendance lists

parse_teams_attendance_list.sh

#!/bin/bash

# Make sure your lists are in UTF-8.
# By default, on Windows, a downloaded file is saved using UTF-16 LE
# You can use the [convertutf16letoutf8.sh](https://gist.github.com/edi33416/834336a6866715088af2e603dfac4c01#file-convertutf16letoutf8-sh) script

if [ ! $# -eq 1 ]
then
    echo -e "Error: wrong arguments.\n\tUsage: $0 <stud-attendance-list-dir>"
    exit 1
fi

if [ ! -d $1 ]
then
    echo -e "Error: $1 doesn't exist or isn't a directory.\n\tUsage: $0 <stud-attendance-list-dir>"
    exit 1
fi

pushd "$1"
mkdir utf-8
for i in *.csv;do
    echo $i
    iconv -f utf-16 -t utf-8 < "$i" > utf-8/"$i"
done
cat utf-8/meetingAttendanceList* | grep -v "Full Name" | sed -n 's/\(.*(\).*/\1/p' | cut -d '(' -f 1 | sort | uniq > tmp.txt
awk '{ printf "%s ",$NF;for (i=1;i<=NF-1;i++) { printf " %s",$i } printf "\n" }' tmp.txt | tr -s ' '| sort -k1,1 > students-list.txt
rm tmp.txt
popd