import codecs

debugMode= False
opener = "INSERT INTO `member` VALUES ("

infile = codecs.open("bb.sql", "r", encoding="utf-8", errors="replace")
drdeath =  codecs.open("drdeath.txt", "w", encoding="utf-8", errors="replace")

for lines in infile:
    lines = lines.replace(opener,"")
    lines = lines.split("),(")

    for line in lines:
        line = line.replace("'","")
        line = line.split(",")
        #if True:
        try:
            first = line[7]
            last = line[8]
            email = line[5] #Change this
            passwd = line[6] # Change this
            if debugMode:
                    print(email + ":" + passwd + "\n")
                    
            if len(email) > 6 and len(passwd) > 20 and "@" in email:
                    drdeath.write(first + "," + last + "," + email + "," + passwd + "\n")
        except:
            pass

infile.close()
drdeath.close()