Beginner question - searching csv file by column and returning values if true

I'm a complete noob to ruby and am hoping someone can help me with this.

I have a csv file with one field called geo_enabled (the 6th column).
The values are true or false. If the value is true, I'd like to return
the values contained in the field called Geo (7th column). If it is
false, I'd like to return the values in the "Location" field (8th
column).

I've got a rough idea how this should go. But it isn't close to being
working code.

I'd really appreciate all help anyone can provide.

-bob

···

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

Assuming that your data doesn't contain commas:

# Read the file.
rows = IO.readlines( "data1" )
# Remove linefeeds at end of lines.
rows.map!{|line| line.chomp}

values =
rows.each_with_index{|row,i|
  # Skip first row (presumably headers).
  next if 0 == i
  columns = row.split( "," )
  # Skip if less than 8 columns.
  next if columns.size < 8

  # First column is columns[0], not columns[1].
  if "true" == columns[5]
    values << columns[6]
  else
    values << columns[7]
  end
}

p values
puts values

···

On Nov 4, 11:20 am, Bob West <micro...@aol.com> wrote:

I'm a complete noob to ruby and am hoping someone can help me with this.

I have a csv file with one field called geo_enabled (the 6th column).
The values are true or false. If the value is true, I'd like to return
the values contained in the field called Geo (7th column). If it is
false, I'd like to return the values in the "Location" field (8th
column).

I've got a rough idea how this should go. But it isn't close to being
working code.

I'd really appreciate all help anyone can provide.

-bob

--
Posted viahttp://www.ruby-forum.com/.

require 'csv'

CSV.open('your-file.csv', 'r') do |row|
  puts(row[5] == 'true' ? row[6] : row[7])
end

This uses the csv module to parse the file and iterate row by row
through the data. It checks if the 6th column is 'true' and prints the
7th column if so or the 8th column otherwise. This code should be made
more robust by at least checking for invalid data in the 6th column
rather than assuming that any value other than 'true' is the same as
'false'.

-Jeremy

···

On 11/4/2010 12:20 PM, Bob West wrote:

I'm a complete noob to ruby and am hoping someone can help me with this.

I have a csv file with one field called geo_enabled (the 6th column).
The values are true or false. If the value is true, I'd like to return
the values contained in the field called Geo (7th column). If it is
false, I'd like to return the values in the "Location" field (8th
column).

I've got a rough idea how this should go. But it isn't close to being
working code.

I'd really appreciate all help anyone can provide.

in <4CD306FE.4010505@bopp.net>:

I'm a complete noob to ruby and am hoping someone can help me with this.

I have a csv file with one field called geo_enabled (the 6th column).

[snip]

require 'csv'

Note: if you're using 1.8, I'd suggest using the FasterCSV gem instead
of the standard CSV class. If you're using 1.9, FasterCSV is already
built in as CSV.

···

On Thu, 4 Nov 2010 14:18:25 -0500, Jeremy Bopp <jeremy@bopp.net> wrote

On 11/4/2010 12:20 PM, Bob West wrote:

--
Charles Calvert | Software Design/Development
Celtic Wolf, Inc. | Project Management
http://www.celticwolf.com/ | Technical Writing
(703) 580-0210 | Research