2 problems when importing data in sqlite3 with .import:
1. It leaves quotes in. If data field is enclosed in quotes, they are
'doubled'. (As reported in this list on Feb 16th)
2. When a string contains a comma, it is interpreted as separator, and
an error is issued, of the type -"4 fields were expected, and there were
6 "
There is a workaround.
For (1), taking all quotes out with a tect processor, and .importing in
".mode list". But not easy if some string data contain a comma, since
then format gets corrupted.
For (2), change the separator character to something else such as | or TAB.
But it is a pity that csv format is not correctly read in. Anyway, that
happens with most database managers I've seen.
Antoni