Vocabletrainer icon indicating copy to clipboard operation
Vocabletrainer copied to clipboard

Published 20 hours ago • verified publisher icon rubengees

CSV Problem during Import

Open obstschale opened this issue 8 years ago • 3 comments

I converted a PDF to CSV and I encountered a problem with your CSV import. Your app does not consider text delimiter in CSVs. For example I have a vocabulary with an comma in it. In CSV you can use " (double quote) or ' (quote) to mark a string as one entry. If you consider this your app could also import this correctly:

sancocho (LA),"Suppe mit Gemüse, Kochbanane und Fleisch oder Fisch",Spanisch-Deutsch

obstschale avatar Dec 23 '15 18:12 obstschale

I didn't even knew that there is some kind of "official" csv. I always thought it was application dependent how it is used. Do you have a link or something where I can found more info about that? But yes, I can implement that.

rubengees avatar Jan 02 '16 23:01 rubengees

Yes there is a RFC which explains the correct use of CSV. RFC 4180. In section 2 there are examples how to use double quotes :)

obstschale avatar Jan 05 '16 09:01 obstschale

Okay, thank you, will have a look.

rubengees avatar Jan 06 '16 11:01 rubengees