groups.py

#!/usr/bin/python

import csv
import re

input_file = csv.DictReader(open("GroupsReport-cleaned.csv"))
for row in input_file:
    clean_members = ""
    # appriver gives us PSV with other garbage so we need to clean it up
    dirty_members = row["Members"].split("|")

    # remove any empty entries
    while("" in dirty_members):
        dirty_members.remove("")

    # extract emails to get rid of the names
    for member in dirty_members:
        email = re.findall(r"[a-z0-9\.\-+_]+@[a-z0-9\.\-+_]+\.[a-z]+", member)
        clean_members = clean_members + "," + email[0]

    print "New-DistributionGroup -Name %s -PrimarySmtpAddress %s@beamland.com -Members %s" % (row["Name"], row["Name"], clean_members[1:])