On Tue, Jan 25, 2011 at 9:36 PM, Kamarulnizam Rahim
<niezam54 / hotmail.com> wrote:
> how do you specifically obtain data for
> example 'Maximise use of natural lighting' only? do i need to filter it
> out as you said?

$ ruby baz.rb
["1.a", "Maximise use of natural lighting", nil, "Active", nil, nil,
nil, nil, nil, nil]

$ cat baz.rb
require 'csv'

CSV.open('ActionPlan.csv','r').each do |row|
  next unless row[0].to_s.match(/\d\.[a-z]/)
  next unless row[1].to_s == 'Maximise use of natural lighting'

  p row
end