求一个正则表达式,解析csv文件的,格式有点复杂

Question

本帖最后由 WDYDXF 于 2013-07-22 14:44:00 编辑

Answer 1

如果不明白csv文件的格式要求,请看:
1.以逗号分隔;
2.字段可以使用双引号包围,也可以不使用双引号包围,但是如果字段中包含逗号,或者结尾或开头包含空格,那么必须以双引号结尾.

Answer 2

string result=Regex.Split(yourstr,@"(?<=[""\s]),(?!\w+"")");

Answer 3

"A11","B16-lesson","APU1 -nuv", "00:16:00", Exit, "APUw,EXE", 80 , 80, ",APW", , ,"invasion19,44"
谢谢您的回复,源行是这个

Answer 4

 string[] result=Regex.Split(yourStr,@",(?=[\s""])");

Answer 5

update:string[] result=Regex.Split(yourStr,@"(?<!""\w+),(?=[\s""])");

Answer 6

高手,您写的这个正则是针对我给的这个例子的.
如果例子换为这个:"A11","B16-lesson","APU1 -nuv","00:16:00",Exit,"APUw,EXE",80,80,",APW",, ,"invasion19,44"
就不对了啊.
请问如果按照2楼的规则,这个正则应该怎么写呢?