SQLite Forum

Issue importing csv file to db
Login
```
nl padron_reducido_ruc.txt  | grep '"' | awk -F'"' 'NF%2!=1{ print $0 }' 
```

shows indeed some (483) lines which have an odd number of " characters.

I do not think import this file should take into account doing anything special with these (") characters.

I also (that's why i have the `nl`) do not see anything special about line 13718893

Because the OP (AxioUK) shared a file which he is not actually using, this will be a difficult problem, because we can only 'guess' that he is doing the conversion, from `|` delimited to `,` delimited, and from ISO-8859 to UTF-8,  the correct way.