From: cristian cristian <lists@...>
Date: 2012-04-19T04:15:48+09:00
Subject: Converting CSV

Hello all!
I'm trying to learn ruby and i'm using it for different tasks and I have
no
one to ask for help. So bear with me :)

I receive CSV files that are separated by semicolon and no quotes.
Received format:

Heading1;Heading2;Heading3;
String1;String2;String3

I would like to make a script for reading all these files and converting
them to CSV files separated by commas and I would like all fields to be
quoted. If possible change encoding to UTF8 without BOM.

Desired format:

"Heading1","Heading2","Heading3"
"String1","String2","String3"

My first problem is how to parse and create a new csv.
I read that I could parse a whole csv to an array of arrays like this:

require 'fastercsv'
array_of_arrays = FasterCSV.read("myfile.csv")

But how should use this array when creating a new file?
I would like to loop through the array.

Any suggestions?

Br
cristian

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