Ignore header line when parsing CSV file

Question

How can the header line of the CSV file be ignored in ruby on rails while doing the CSV parsing!! Any ideas

Answer 1

Easier way I have found is by doing this:

file = CSV.open('./tmp/sample_file.csv', { :headers => true })
# <#CSV io_type:File io_path:"./tmp/sample_file.csv" encoding:UTF-8 lineno:0 col_sep:"," row_sep:"\n" quote_char:"\"" headers:true>

file.each do |row|
 puts row
end

Answer 2

If you're using ruby 1.8.X and FasterCSV, it has a 'headers' option:

csv = FasterCSV.parse(your_csv_file, {:headers => true}) #or false if you do want to read them

If you're using ruby 1.9.X, the default library is basically FasterCSV, so you can just do the following:

csv = CSV.parse(your_csv_file, {headers: true})

Answer 3

csv = CSV.read("file")

csv.shift # <-- kick out the first line

csv # <-- the results that you want

Answer 4

I have found the solution to above question. Here is the way i have done it in ruby 1.9.X.

csv_contents = CSV.parse(File.read(file))
csv_contents.slice!(0)
csv=""
csv_contents.each do |content|
    csv<<CSV.generate_line(content)
end