csv2json.rb

#!/usr/bin/env ruby

require 'json'

lines = $stdin.map {|line| line }.reverse

titles = lines.pop.split(",")

results = Array.new
lines.each{|line|
  line = line.gsub("\"<Null>\"", "")
  line = line.chomp
  values = line.split(",")
  if values.length == titles.length
    r = Hash.new
    for i in 0..titles.length-1
      key = titles[i].chomp
      value = values[i].gsub(/^\"(.+)\"$/, '\1')
      r[key] = value
    end
    r["date"] = r["date"].to_f
    r["number"] = r["number"].to_i
    r["applyToAll"] = r["applyToAll"].to_i
    results.push(r)
  end
}

print(results.to_json)