Trims Goodreads CSV files so they import into Delicious Library essential data only.

goodreads_csv_filter.rb

#!/usr/bin/env ruby -w
#
# Trims Goodreads CSV files so they import into Delicious Library essential data only.
#

require 'rubygems'
require 'faster_csv'

path = ARGV.empty? ? "/Users/rgreen/Downloads/goodreads_export.csv" : ARGV[0]

puts "Title,Author,ASIN,ISBN"

text = ""
File.open(path) { |file| text = file.read }
text.gsub!(/",="/, "\",\"")

FasterCSV.parse(text, :headers => true) do |row|
  puts "\"#{row[0]}\",\"#{row[1]}\",\"#{row[4]}\",\"#{row[4]}\""
end