sender_email, file_name
[email protected], utf16filename.xlxs
[email protected], utf16filename.xlxs
[email protected], utf8filename1.pptx
[email protected], utf8filename2.pdf
[email protected], utf8filename3.docx
[email protected], utf8filename4.docx
[email protected], utf8filename5.docx

sender_email, file_name
[email protected], utf8filename1.pptx
[email protected], utf8filename2.pdf
[email protected], utf8filename3.docx
[email protected], utf8filename4.docx
[email protected], utf8filename5.docx

import csv
with open ('MixedUTF8andUTF16FileNamesAndSenderEmail.csv', 'r') as inFile:
readFile = csv.reader(inFile)
for row in readFile:
    try:
        sender_email = row[0]
        file_names = row[1].decode('ascii')
        print sender_email+'t'+file_names
        with open('asciionlycharacters.txt', 'a') as finalFile:
            finalFile.writerows(sender_email+'t'+file_names)
    except:
        pass

sender_email  file_name
utf8filename1.pptx
utf8filename2.pdf
utf8filename3.docx
[email protected]
[email protected]