From: Jan Svitok <jan.svitok@...>
Date: 2006-07-23T18:59:48+09:00
Subject: Re: converting a text file into an "insert into ..." file

In case you need escaping there is a module for parsing CSV in stdlib.
http://www.ruby-doc.org/stdlib/libdoc/csv/rdoc/index.html

otherwise just

ruby -ne 'puts "insert into some_table values (#{$_.strip});"' < data.csv

On 7/23/06, kublaikhan55@hotmail.com <kublaikhan55@hotmail.com> wrote:
> Hi,
> I have a csv delimited file that I'd like to 'insert into some_table
> table values ...' file. Thus I have a file where each row is of the
> sort:
>
> value1, value2, value3, value4
>
> and I'd like to convert the file into a file where each row looks
> like::
>
> insert into some_table values (value1, value2, value3, value4)
>
> How may I efficiently do this?
>
> Thanks for your help.
> gk
>
>
>