from __future__ import print_function import csv import sys import re output = "" def print_out(info, end="\n"): global output output = output+info+end def flush(): f = open("output.txt", "w") f.write(output) f.close() def normal_phone(num): if(num == ""): return num num = re.sub("[^0-9|\*|\+]","", num) if(num[0] != "+" and num[0] != "0" and num[0] != 1 and num[0] != "*"): num = "0" + num return num with open("test3.csv") as csvfile: spamreader = csv.reader(csvfile, delimiter=',', quotechar='"') i = 0 exp = re.compile("\([a-z|A-Z|\*]+\)",re.IGNORECASE) for row in spamreader: i = i+1 if(len(row) > 0): for cur in row: cur = cur.split('\n') if(len(cur) == 0): print_out("") continue for phone in cur: #if(phone.index("@") != -1): #continue status = False for res in exp.finditer(phone): status = True if(res.group(0) == " "): continue num = normal_phone(phone[:res.start()-1]) type = phone[res.start()+1:len(phone)-1] print_out(type+","+ num, end=",") if(not status): print_out("Mobile,"+normal_phone(phone),end="\n") print_out("",end="\n") """ if(i==5303): print(cur) break if(i==5303): break if(i==5303): break""" print(i) flush()