CODEWITHSUNDEEP
rubycsv
Kashiftufail
Kashiftufail

Reputation: 10885

How write into CSV file properly

i am using ruby 1.9.2 and also use its csv library.I want to write in csv properly just

like this

name,country_code,destination,code
Afghanistan,93,Bamain,51
Afghanistan,93,Bamain,52
Afghanistan,93,Bamain,53
Afghanistan,93,Parwan,91

My code is this

def export_data
  @coun = Country.all(:limit => 10)
  header = "name,country_code,destination,code"
  file = "my_file.csv"
  File.open(file, "w") do |csv|
    csv << header
    @coun.each do |c|
      csv << [c.name, c.country_code, c.user_id, c.subscriber_id]       
      # How puts line break here
    end
  end
  send_file(file)
end

I have mention above how puts i line break there in CSV file and also omit this sigh which

covers every row in CSV"[]" 

 Like   ["Finland",1,1,2334]

Thanks in advance..

Upvotes: 20

Views: 40572

Answers (2)

ABrukish
ABrukish

Reputation: 1452

I think general CSV writer will be good enough for you:

require 'csv'
file = "my_file.csv"
CSV.open( file, 'w' ) do |writer|
  @coun.each do |c|
    writer << [c.name, c.country_code, c.user_id, c.subscriber_id]
  end
end

Upvotes: 78

Marlin Pierce
Marlin Pierce

Reputation: 10081

csv << "\n"

Stackoverflow requires 30 characters in an answer, but I don't know what more to say.

Upvotes: 39

Related Questions