From: "Jack E." <lists@...>
Date: 2013-02-23T00:47:27+09:00
Subject: Re: Ruby Script read excel file to then read a directo

I have now come up with this script that does part one but im getting a 
error on part 2

dont know if anyone could help

regards


require 'fileutils'
require 'spreadsheet'

input = "/Users/eccleshall/ImageCleanUp/" #where images are stored
output = "/Users/eccleshall/ImageCleanUp/Keep" #where images will be 
copied to

book = Spreadsheet.open 
'/Users/eccleshall/Desktop/ImageCleanUpScript/B002.xls' #opens workbook

sheet1 = book.worksheet 0 # sets worksheet

sheet1.each do |row| #for each row output
  puts row

    Dir.glob("/Users/eccleshall/ImageCleanUp/" row).each do|f| #search 
/Users/eccleshall/ImageCleanUp/ for files startig with row
      puts f
    end
end

error i'm getting

ImageCleanUp.rb:14: syntax error, unexpected tIDENTIFIER, expecting ')'
...s/eccleshall/ImageCleanUp/" row).each do|f| #search /Users/e...

-- 
Posted via http://www.ruby-forum.com/.