import re
file = open('C:\\Users\\lvhao\\Desktop\\test3.xlsx','w')
with open('C:\\Users\\lvhao\\Desktop\\test2.xlsx','r') as f:
dic = {}
for index,line in enumerate(f):
#print(line,index)
linelist = line.split('\t')
if '(' in linelist[1]:
str = re.sub("[A-Za-z\.\-é]", "", linelist[1])
print(str,linelist[1])
# file.write(linelist[0] +'\t'+ str)
# else:
# file.write(line)
如何过滤掉表格一列的包含英文的
最新推荐文章于 2020-06-03 21:03:35 发布