From: "Jesús Gabriel y Galán" <jgabrielygalan@...>
Date: 2011-01-26T00:45:27+09:00
Subject: Re: Obtain 'CSV' data

On Mon, Jan 24, 2011 at 10:55 PM, Kamarulnizam Rahim
<niezam54@hotmail.com> wrote:
> Hi Robert,
>
> This is the result i had when iam using ur code above:
>
> "Issue,,Risk/Opportunity,Compliance,Consequence,Current Status,Due
> Date,Priority,Responsibility,Probability\n"
> ["Issue,,Risk/Opportunity,Compliance,Consequence,Current Status,Due
> Date,Priority,Responsibility,Probability\n"]
> nil
> "1,Efficiency (Energy),No
> Action,Unknown,Neutral,Active,,Medium,,Possible\n"
> ["1,Efficiency (Energy),No
> Action,Unknown,Neutral,Active,,Medium,,Possible\n"]
> nil
>
> I dont know why it returned value 'nil' instead of 'active'.

Because you said the fields were separated by '|' and this is why
James and Robert were doing this:

line.split(/\s*\|\s*/) # split using | as the separator

but now it seems your fields are separated by commas, which should
require something like:

line.split(/\s*,\s*/)

Which one is it: commas or pipes?

Jesus.