Jesús Gabriel y Galán
2/16/2009 3:42:00 PM
On Mon, Feb 16, 2009 at 3:25 PM, Nick Hoyle <niho28@tiscali.co.uk> wrote:
> How would i go about parsing a csv from the web eg yahoo finance stock
> data into my database table called stocks?
If you have a url to download the csv, you can read it with something
like open-uri.
Then use a CSV library like FasterCSV for csv parsing, and then I
would use a ORM
(Sequel, ActiveRecord or Datamapper come to mind) to create the rows
in your table.
Hope this helps,
Jesus.