擅长:python、mysql、java
<p>使用<a href="https://regexone.com/references/python" rel="nofollow noreferrer">regular expression</a>。你知道吗</p>
<pre><code>import csv
import re
with open('input.csv') as fin,
open('output.csv', 'wb') as fout:
csv_in = csv.reader(fin, delimiter = '\t')
csv_out = csv.writer(fout)
for row in csv_in:
matchList = re.findall(r'\d{6}', row, flags=0)
csv_out.writerow(matchList)
</code></pre>
<p>模式类似于“\d{6}”或“/d/d/d/d/d/d”</p>