On Aug 5, 2006, at 7:45 PM, junkone / rogers.com wrote:

> A sample data is in this link
> http://www.geocities.com/murthysuresh/ABC.TXT

> I am not sure if this is feasible

Sure it is.  Here's the skeleton code to get you going:

   require "faster_csv"

   File.open("ABC.TXT") do |file|
     current_price = file.gets.parse_csv(:row_sep => "\r\r\n")[1]
     file.gets
     FCSV(file, :row_sep => "\r\r\n", :headers => true) do |csv|
       csv.each do |row|
         # ... use current_price and row here ...
       end
     end
   end

You may not need those odd :row_sep settings.  The file I downloaded  
had very odd line endings, but that may have been a web server or  
browser mucking with the data along the way.

Hope that helps.

James Edward Gray II