Process time table data for vane.

vane.rb

lines = File.open('time_table.csv', 'rb') { |file| file.read }

require 'time'

File.open('result_time_table.csv', 'w') do |csv|
  lines.each do |line|
    tokens = line.chomp.split(",")
    if tokens[1] == ":"
      csv.puts tokens.join(",")
      next
    end
    
    date = tokens[0]
    time = tokens[1]
    start_time = Time.parse("#{date} 08:30")
    end_time = Time.parse("#{date} #{time}")
    tokens[2] = (end_time - start_time) / 60
    
    time = tokens[3]
    start_time = Time.parse("#{date} 18:00")
    end_time = Time.parse("#{date} #{time}")
    tokens[4] = (end_time - start_time) / 60
    
    csv.puts tokens.join(",")
  end
end