请教一个 Python 中字段切割问题

exec('a=[6898,"RAAF Williams, Laverton Base","Laverton","Australia","YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"]')

好方法，命令执行 /代码执行严重漏洞都你这么写出来的

@qwjhb

正则表达式，如果单词是有引号的话

@wuwukai007 #4 看来只能用 ^(\d+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+),(.+)$ 这种来分离了

这样行不行
!(img)[https://carbon.now.sh/?bg=rgba(171%252C184%252C195%252C0)&t=a11y-dark&wt=none&l=python&ds=false&dsyoff=20px&dsblur=68px&wc=true&wa=true&pv=0px&ph=0px&ln=false&fl=1&fm=Hack&fs=14px&lh=142%2525&si=false&es=2x&wm=false&code=%25253E%25253E%25253E%252520s%25250A'6898%25252C%252522RAAF%252520Williams%25252C%252520Laverton%252520Base%252522%25252C%252522Laverton%252522%25252C%252522Australia%252522%25252C%25255C%25255CN%25252C%252522YLVT%252522%25252C-37.86360168457031%25252C144.74600219726562%25252C18%25252C10%25252C%252522O%252522%25252C%252522Australia%25252FHobart%252522%25252C%252522airport%252522%25252C%252522OurAirports%252522%25255Cn'%25250A%25253E%25253E%25253E%252520import%252520csv%25250A%25253E%25253E%25253E%252520list(csv.reader(%25255Bs%25255D))%25250A%25255B%25255B'6898'%25252C%252520'RAAF%252520Williams%25252C%252520Laverton%252520Base'%25252C%252520'Laverton'%25252C%252520'Australia'%25252C%252520'%25255C%25255CN'%25252C%252520'YLVT'%25252C%252520'-37.86360168457031'%25252C%252520'144.74600219726562'%25252C%252520'18'%25252C%252520'10'%25252C%252520'O'%25252C%252520'Australia%25252FHobart'%25252C%252520'airport'%25252C%252520'OurAirports'%25255D%25255D]

不好意思，贴乱了
试试这个
import csv
>>> list(csv.reader([your_string]))

这个可以解决你的问题：
https://community.simplilearn.com/threads/how-to-split-a-string-at-commas-but-ignore-commas-inside-double-quotes-%E2%80%9C-%E2%80%9D.25273/

import csv
s = '6898,"RAAF Williams, Laverton Base","Laverton","Australia",\\N,"YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"'
splitted = list(csv.reader([s], delimiter=',', quotechar='"'))[0]
print(splitted)

```
import csv

s = '6898,"RAAF Williams, Laverton Base","Laverton","Australia",\\N,"YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"'

splitted = list(csv.reader([s], delimiter=',', quotechar='"'))[0]

print(splitted)
```

@retanoj 能不能用？ 脚本处理现成格式化文本怕人插命令进来？ 干脆删了 exec 好了

ast.literal_eval('[6898,"RAAF Williams, Laverton Base","Laverton","Australia","YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"]')

@noreply69 #9
@retanoj #7

感谢 这两段代码都能解决

@Akkuman #12
@qwjhb #11
因为是从文本文件一行一行读取 你们括号里的部分相当于已经成功分离了==

@huyinjie 不是成功分离，只是前后拼接了方括号

@qwjhb
是的，能用能用。
你知道的，一句“能不能用？”已经能说明很多问题了。

当中那个\N 能去掉吗？不去掉的话好像报错？

直接整个 csv 文件也可以读进来的

s = your_str
shuangyinhao_count = 0
result = []
temp = ''

for i in s:
if i == '"':
shuangyinhao_count += 1
elif i == ',':
if shuangyinhao_count == 1: # 当双引号数量为 1 时,继续添加字符而不做处理
temp += i
else:
result.append(temp)
temp = ''
else:
temp += i

if shuangyinhao_count == 2:
shuangyinhao_count = 0

result.append(temp)

print(result)

正则分隔
import re

str = '6898,"RAAF Williams, Laverton Base","Laverton","Australia",\\N,"YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"'
pattern = re.compile(r'\"[^\"]+\"\,|[^\"\,]+\,');
print(pattern.findall(str))

@qwjhb @retanoj 安全地解析字符串成 Python 对象可以用 ast.literal_eval，遇到运算符会抛出异常


import ast
ast.literal_eval('6898,"RAAF Williams, Laverton Base","Laverton","Australia","N","YLVT",-37.86360168457031,144.74600219726562,18,10,"O","Australia/Hobart","airport","OurAirports"')
(6898, 'RAAF Williams, Laverton Base', 'Laverton', 'Australia', 'YLVT', -37.86360168457031, 144.74600219726562, 18, 10, 'O', 'Australia/Hobart', 'airport', 'OurAirports')

@Akkuman #15 感谢 可以使用

@smallpython #19 感谢 这种相当于 C 语言中 getchar 最初想到这个方法就是感觉麻烦些

@chenstack #21
N 两边没有双引号 ast.literal_eval 无法解析

@levelworm #17 是的 不去掉会报错 可以使用 replace 成"\N"的方法曲线解决==

@huyinjie 多谢，这样要不写个简单的 parser 吧？虽然我觉得上面的一些解法更简单。

pandas 用条件扩充字段