Problem with particolar CSV Tesxt File

Hi to everybody. I have to read in a BIRT Report a CSV File with 3 fields.
Num (integer), Desc (string), value (decimal)
My problem is that on the string field i have same record with more than 2 ".
Example: 1,"BIRT "Designer Pro" Actuate, 250.45

I have this error: Cannot fetch the next datarow. Invalid file format.
I need to read this file and this file cannot change.
Wait for suggest,
best regards

Giorgio

Find more posts tagged with

Comments

janderegg

Could you post an example of csv file you are using?

gcolaf

Here the example:

PRODUCTNAME,QUANTITYINSTOCK,MSRP
string, integer, decimal
"1969 Harley "Davidson" Ultimate Chopper",7933,95.7
"1952 Alpine Renault 1300",7305,214.3
"1996 Moto Guzzi 1100i",6625,118.94
"2003 Harley-Davidson Eagle Drag Bike",5582,193.66
"1972 Alfa Romeo GTA",3252,136

As you can see in the 3rd line the word Davidson is with ". I need to read the string field without consider the character " as delimiter.
Remeber:i have no possibility to change the file

janderegg

Normally, when you have quote in a String you will have to double it.

A string containing a double quote would be:
"1969 Harley ""Davidson"" Ultimate Chopper"

gcolaf

Ok,
i will try to change the CSV file.
Thanks to everybody.
Giorgio