擅长:python、mysql、java
<p>我会使用带有CVS解析器的语言。尝试解析当前行,如果有错误,请连接下一行并重试:例如,使用ruby:</p>
<pre><code>ruby -rcsv -ne '
chomp
loop do
begin
row=CSV.parse_line($_)
# if no error thrown, we have a parseable line
puts row.inspect
break
rescue
# grab the next line and try again
$_ += gets
end
end
' << END
a,b,c,d,e
1,2,3,4,5
"2013-11-19 10:09:09","0","I","NOT SET ","
simple string "
"a 1","b 2","c 3","d 4","e 5"
END
</code></pre>
^{pr2}$