How Can I insert another column data into the CSV file when I use FasterCSV?

Rails
1

Hi, All,
Suppose I have a CSV file, there is data in it.

  •             Column 1     Column2              Column 3

Column 4
Row1 a b c
Row2 a2 b2 c2*

You know, the column 4 is no data
Now, I would like to insert data to Column 4, after save, the CSV file
will
be:

  •             Column 1     Column2              Column 3

Column 4
Row1 a b
c d
Row2 a2 b2
c2 d2*

How can I do that?

Any suggestion would be quite appreciated.
Thanks.
Wesley C…

2

When I use
fcsv=FasterCSV.open(“test.csv”, “a+”)
fcsv << “Hello”

I can only add “Hello” to the end row of the csv.

But how can I insert another column to the CSV?

Thanks.
Wesley C…

2009/6/14 Maurício Linhares [email protected]

3

I said open the file, parse it again and re-generate it with the new
column:

FasterCSV.open(“path/to/file.csv”, “w”) do |csv|
FasterCSV.foreach(“path/to/new/file.csv”) do |row|
csv << (row.fields + [ new_column_value ])
end
end

Maurício Linhares
http://codeshooter.wordpress.com/ | http://twitter.com/mauriciojr

4

Have you looked at the FasterCSV docs?

http://fastercsv.rubyforge.org/classes/FasterCSV.html

Just parse the file and then write to it again with the new column.

Maurício Linhares
http://codeshooter.wordpress.com/ | http://twitter.com/mauriciojr