Script to take AWS right sizing output and parse out tags into CSV columns, for easier interpretation

tagcolumns.rb

require "csv"

inputarray = ARGV
if inputarray.length != 2
  puts "usage: ruby tagcolumns.rb <input filename> <output filename>"
  exit
end

a = CSV.read(ARGV[0])
all_tags = Hash.new
csv_columns = a[0].length

a[1..a.length-2].each do |row|
  begin
    kvhash = Hash.new("")
    kvpairs = row[row.length-1].split(" | ")
    kvpairs.each do |kv|
      k,v = kv.split(":")
      kvhash[k] = v
      all_tags[k] = ""
    end
    row << kvhash
  rescue
    row << {}
  end
end

headers = a[0][0..csv_columns-2]
  all_tags.each do |k,v|
    headers << k
    all_tags[k] = headers.length-1
  end

CSV.open(ARGV[1], "wb") do |csv|
  csv << headers
  a[1..a.length-2].each do |row|
    new_row = row[0..-3]
    row[-1].each do |k,v|
      new_row[all_tags[k]] = v
    end
    if new_row.length < headers.length
      new_row[headers.length-1] = nil
    end
    csv << new_row
  end
end