擅长:python、mysql、java
<p>使用<strong>正则表达式</strong>:</p>
<pre><code>import re
results = [re.match('(.*?\|)(.*?\|)(.*?\|)(.*?\|)(.*?\|)(.*?\|)', line).groups() for line in open('file.txt')]
# filter just the rows with fourth column > 10000
results = [result for result in results if int(result[3]) > 10000]
</code></pre>
<p>使用<strong>拆分</strong>:</p>
<pre><code>results = [line.split('|')[0:-1] for line in open('file.txt')]
# filter just the rows with fourth column > 10000
results = [result for result in results if int(result[3]) > 10000]
</code></pre>