topic Re: Read csv file in Talend Studio

Read csv file

_AnonymousUser — Thu, 14 Jan 2016 15:18:45 GMT

Hello,

I have a csv file that contains some fields with " as enclocure.
For example :

526;Mico-jean;Thierry;01/01/2010;01/01/2010
528;"Robert;rené";Rene;01/01/2010;01/01/2010

When i check the schema of my lines, i get all the time an error on the first line. I used a flow to insert the rejected lines into a table. and the ligne that i found is : ¿526 - Mico-jean - Thierry - 01/01/2010 - 01/01/2010.

Do you have an idea please ?

Thank you

Re: Read csv file

_AnonymousUser — Thu, 14 Jan 2016 15:24:05 GMT

When i desactivate the Option CSV the problem is resolved ! but i need the specify the enclosures

Re: Read csv file

Anonymous — Fri, 15 Jan 2016 08:39:33 GMT

Hi,
Have you tried to choose a "Text enclosure" (in the csv options) and select the "\"" (double quote)?
Best regards
Sabrina

Re: Read csv file

_AnonymousUser — Mon, 18 Jan 2016 10:10:13 GMT

Thanks Sabrina, yes i have the right csv option parameters.

The problem is caused by the encoding of my input "UTF-8 with BOM". So as my first field is an integer it's rejected because of the first char is not a number.

Now i have two workaround : add a header to my file or remove the first char and convert to Integer. The first option is not possible currently, so i'm working on the second one

Re: Read csv file

Anonymous — Tue, 19 Jan 2016 03:59:46 GMT

Hi,
Feel free to let us know if your second solution works.
Best regards
Sabrina