Blink2Piazza.py

#!/usr/bin/env python
"""Translate from a blink student list into a list of emails that can
be used to populate Piazza.

The first lines of a Blink student list are:

Sect ID	Course	Title	SecCode	Instructor	
785801	CSE103	Practical Intro/Prob & Stats	A00	Freund, Yoav

Sec ID	PID	Student	Credits	College	Major	Level	Email	
785801	A10318231	Abid, Michael E	4.00	RE	CS26	SR	mabid@ucsd.edu
785801	A10917852	Abney, Beck Graham	4.00	SI	CS26	FR	babney@ucsd.edu

"""

import sys
f = open(sys.argv[1], 'r')
for i in range(4):      #skip header lines
    f.readline()

for line in f.readlines():
    # parts = line.strip().split('\t')
    SecID, PID, Student, Credits, College, Major, Level, Email= line.strip().split('\t')
    Last, First = Student.split(',')
    Email=Email.strip()
    userID,emailDomain = Email.split('@')
    print ('%s, ' % Email),