擅长:python、mysql、java
<p>使用正则表达式(python中的<code>re</code>模块)的简单解决方案:</p>
<pre><code>import re
sql = "(10001,'AEX','CCC','X12344','John, Doe','Not indicated','None','No','No','No','\r\n'),(10002,'AEX','CCC','X12344','John, Doe','Not indicated','None','No','No','No','\r\n')"
groups = re.findall('\([^()]*\)', sql)
lists = [list(eval(lst[:-6]+')')) for lst in groups]
</code></pre>
<p><code>'\([^()]*\)'</code>regex捕获所有括号之间的所有字符(<code>()</code>)</p>
<p><code>lst[:-6]+')'</code>删除尾随的<code>,'\r\n')</code>并追加<code>)</code>(生成完整的“元组字符串”),以便<code>eval</code>平稳运行并返回元组,然后使用<code>list()</code>将其转换为列表</p>