擅长:python、mysql、java
<p>你可以这样做:</p>
<pre class="lang-py prettyprint-override"><code>with open("data.txt", "r") as f:
for line in f.readlines():
columns = line.split(", ") # Split by ", "
columns[3] = "".join(columns[3:]) # Merge columns 4 to ... last
columns[3] = columns[3].replace("\"", "").replace(",", "")` # Removing unwanted characters
del columns[4:] # Remove all unnecessary columns
print("%s | %s | %s | %s" % (columns[0], columns[1], columns[2], columns[3]))
</code></pre>
<p>我的数据.txt文件:</p>
<pre><code>1, "ABC", BCD, "EDG",GHT\2\TST"
2, "CBA", DCB, "GDV",DHZ,\2RS"
</code></pre>
<p>输出:</p>
<pre><code>1 | "ABC" | BCD | EDGGHT\2\TST
2 | "CBA" | DCB | GDVDHZ\2RS
</code></pre>
<p>只有最后一列包含逗号时,此解决方案才有效。你知道吗</p>