Kashiftufail Kashiftufail - 3 months ago 14
Ruby Question

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..

Answer
csv << "\n"

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