carolineartz
11/5/2014 - 1:01 AM

Parsing CSV- different ways

Parsing CSV- different ways


filename = 'data.csv'
file = File.new(filename, 'r')

file.each_line("\n") do |row|
  columns = row.split(",")
  
  break if file.lineno > 10
end

#######

require 'csv'

CSV.open('data.csv', 'r', ';') do |row|
  puts row
end


#######

#require 'rubygems'
require 'faster_csv'

FasterCSV.foreach("data.csv", :quote_char => '"', :col_sep =>';', :row_sep =>:auto) do |row|
  puts row[0]
end

#######

#require 'rubygems'
require 'csv'

CSV.foreach(file) do |values|
  puts values[0]
end

#######

require "csvscan"

open("data.csv") do |io|
  CSVScan.scan(io)  do|row|
    puts row
  end
end