email_parser.py

#!/usr/bin/env python3

import csv
import re

with open('customer_interview_list.csv') as file: 
	reader = csv.reader(file, delimiter=';')

	for row in reader:
		column = row[13]
		column = column.strip() # remove unnecessary whitespace
		if not column: continue

		emails = re.findall(r'[\w\.-]+@[\w\.-]+\.[\w]+', column)
		if not emails: continue

		emails = list(set(emails)) # removes duplicates because a set is supposed to have unique entries
		print("E-Mails Found: {}".format(emails))