如何在Ruby中拆分CSV字符串?

str=<<EOF
2412,21,"Which of the following is not found in all cells?","Curriculum","Life and Living Processes, Life Processes",,,1,0,"endofline"
EOF
require 'csv' # built in

p CSV.parse(str)
# That's it! However, empty fields appear as nil.
# Makes sense to me, but if you insist on empty strings then do something like:
parser = CSV.new(str)
parser.convert{|field| field.nil? ? "" : field}
p parser.readlines

这不是正则表达式的合适任务。你 需要 一个CSV解析器,Ruby内置了一个:

http://ruby-doc.org/stdlib/libdoc/csv/rdoc/classes/CSV.html

还有一个可以说是一流的第三部分库:

http://fastercsv.rubyforge.org/

编辑:我未能读取Ruby标记。好消息是,即使语言细节不对,指南也会解释构建这个模型的理论。对不起的。

这里有一个很棒的指南:

http://knab.ws/blog/index.php?/archives/10-CSV-file-parser-and-writer-in-C-Part-2.html

csv编写器在这里:

http://knab.ws/blog/index.php?/archives/3-CSV-file-parser-and-writer-in-C-Part-1.html

这些例子涵盖了csv中有一个带引号的文本(可能包含也可能不包含逗号)的情况。

text=<<EOF
2412,21,"Which of the following is not found in all cells?","Curriculum","Life and Living Processes, Life Processes",,,1,0,"endofline"
EOF
x=[]
text.chomp.split("\042").each_with_index do |y,i|
  i%2==0 ?  x<< y.split(",") : x<<y
end
print x.flatten

$ ruby test.rb
["2412", "21", "Which of the following is not found in all cells?", "Curriculum", "Life and Living Processes, Life Processes", "", "", "", "1", "0", "endofline"]

今天早上,我偶然发现了Ruby on Rails的CSV表导入器项目。最终您会发现代码很有用:

Github TableImporter