midd_screen_grab.rb

#! /usr/bin/ruby
require 'rubygems'
require 'nokogiri'
require 'open-uri'

DIRECTORY_QUERY_URL_FOR = "https://web.middlebury.edu/database/directory/?cn="

"A".upto("Z") do |letter|
  
  url = "#{DIRECTORY_QUERY_URL_FOR}#{letter}"
  doc = Nokogiri::HTML(open(url))
    
  doc.css("tr").each do |item|
    # initialize
    output ||= []    
    # set
    output.push item.css("td:nth-child(1)").text
    output.push item.css("td:nth-child(2)").text
    output.push item.css("td:nth-child(3)").text
    output.push item.css("td:nth-child(4)").text
    output.push item.css("td:nth-child(5)").text
    # output into in csv format
    puts '"' + output.map { |v| v.strip }.join("\",\"") + '"'
    # reset
    output.clear
  end
end