On 16 Aug 2010, at 9:44pm, Peng Yu wrote: > I guess that I misunderstood .mode csv. It seems that .import don't > treat double quote specially. So .import only can read file that has > some character (set by .separator) separates different fields?
Correct. '.import' pays attention to '.separator'. '.import' does not handle quoted fields correctly. If you want an importing job done properly, write your own software to import your own format exactly the way you want it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
