ticktick csv export

process.rb

require "csv"
require "pry"

rows = CSV.read("./ticktick.csv", headers: true)
rows = rows.select { |row| row["Completed Time"].nil? }

CSV.open("./ticktick2.csv", "w") do |csv|
  csv << rows[0].headers

  rows.each do |row|
    csv << row.fields
  end
end

hash = {}

rows.each do |row|
  hash[row["List Name"]] ||= []
  hash[row["List Name"]] << "#{row['Title']} #{row['Content']}"
end

hash.each do |key,v|
  CSV.open("./tick-#{key.gsub(' ', '-')}.csv", "w") do |csv|
    v.each do |item|
      csv << [item]
    end
  end
end

# binding.pry