擅长:python、mysql、java
<p><em>我在python中有这样一个正则表达式,它试图获取数据的第一个逗号分隔字段。换句话说,例如,“10月14日800.00(SPX1418J800)”</em></p>
<p>只需使用<code>split</code>,在逗号上拆分并获得第一个元素,就不需要re:</p>
<pre><code>s="14 Oct 800.00 (SPX1418J800),0.0,0.0,1067.10,1071.40,0,0,14 Oct 800.00 (SPX1418V800),0.09,0.0,0.0,0.05,0,25"
print(s.split(",",1)[0])
14 Oct 800.00 (SPX1418J800)
s1 = "11 Jan 1075.00 (SPXW1128A1075-E),0.0,0.0,215.30,217.00,0,0,11 Jan 1075.00 (SPXW1128M1075-E),0.05,-0.10,0.05,0.10,10,15535,"
print(s1.split(",",1)[0])
11 Jan 1075.00 (SPXW1128A1075-E)
</code></pre>
<p>如果你只想知道根据你问题的结果你不想知道的东西,你可以再次拆分:</p>
<pre><code>s = "14 Oct 800.00 (SPX1418J800),0.0,0.0,1067.10,1071.40,0,0,14 Oct 800.00 (SPX1418V800),0.09,0.0,0.0,0.05,0,25"
print(s.split(",",1)[0].rsplit(" ",1)[-1])
(SPX1418J800)
</code></pre>
<p>或者简单地使用csv模块:</p>
<pre><code>import csv
with open(my.csv) as f:
reader = csv.reader(f,delimiter=",")
for line in reader:
print(line[0])
14 Oct 800.00 (SPX1418J800)
11 Jan 1075.00 (SPXW1128A1075-E)
</code></pre>