# -*- coding: utf-8 -*-
def request_time_helper(time)
  if time =~ /[0-9]{3,4}/
    if time == "2412"
      return "AM"
    elsif time == "1224"
      return "PM"
    else
      array = time.scan(/[0-9]{1,2}/)
      if array[0].to_i <= 24 && array[1].to_i <= 24
        return array[0] + "時-" + array[1] + "時"
      end
    end
  elsif time == "0"
    return '\N'
  elsif time =~/[0-9]{1,2}/
    if time.to_i <= 24
      return time.to_s + "時"
    end
  end
  return '\N'
end

csv = '/tmp/warehouses_customers.csv'

open(csv) do |file|
  while line = file.gets()
    array = line.split(',')
    array[7] = request_time_helper(array[7])
    puts array.inject{|r,i| r + "," + i}
  end
end