使用Ruby CSV更改导出CSV中的字段分隔符/分隔符 [英] Changing field separator/delimiter in exported CSV using Ruby CSV

问题描述

是否可以将默认字段分隔符从逗号更改为某些其他字符，例如'|'用于导出？

到文件：

  CSV.open（myfile.csv，w，{：col_sep =>\t}）do | csv | 
 csv<< [row，of，CSV，data] 
 csv< [another，row] 
＃... 
 end 
  

到字符串：

  csv_string = CSV.generate（：col_sep =>\t）do | csv | 
 csv<< [row，of，CSV，data] 
 csv< [another，row] 
＃... 
 end 
  

以下是有关CSV的当前文档： http://ruby-doc.org /stdlib/libdoc/csv/rdoc/index.html

Is it possible to change the default field separator from comma to to some other character, e.g '|' for exporting?

解决方案

Here's an example using a tab instead.

To a file:

CSV.open("myfile.csv", "w", {:col_sep => "\t"}) do |csv|
  csv << ["row", "of", "CSV", "data"]
  csv << ["another", "row"]
  # ...
end

To a string:

csv_string = CSV.generate(:col_sep => "\t") do |csv|
  csv << ["row", "of", "CSV", "data"]
  csv << ["another", "row"]
  # ...
end

Here's the current documentation on CSV: http://ruby-doc.org/stdlib/libdoc/csv/rdoc/index.html

这篇关于使用Ruby CSV更改导出CSV中的字段分隔符/分隔符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！