From: James Gray <james@...>
Date: 2009-03-02T01:23:14+09:00
Subject: Re: How to find the specific row of CSV file.

On Mar 1, 2009, at 8:55 AM, Salil Gaikwad wrote:

> thanx for quick reply
> sorry i didn't get that row but i find out different with same problem
> please find the attachment it gives me error (not exactly but not  
> saved
> true value in database)on line no 4 as given below.
>
> B001K809QG,18736111556,,,,A,1,3.04,3.04,Aaron Lacrate,B-more Gutter
> Music Vol Too! [Explicit],,Delicious Vinyl

How should this data be read?  Does a simple:

   fields = line.split(",")

work for this case?

>> What strikes me as odd is that you have comma as both the :col_sep  
>> and
>> the
>> :quote_char. The FasterCSV defaults are comma for :col_sep and " for
>> :quote_char.
>
> ya i know but i want one special character as :quote_char which not  
> in a
> csv file so i try comma if csv file is comma separator, bar for bar
> separator and so on.....

FasterCSV handle's proper escaping if the character is in your file,  
so you shouldn't need to worry about this.

James Edward Gray II