Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Read csv file

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

Labels (2)
4 Replies
_AnonymousUser
Specialist III
Specialist III
Author

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

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

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
Anonymous
Not applicable

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