For those of you who use SQLite to prepare CSV for import/open into Excel beware of this problem:
"Text","Next bit is a reference id","A001" "text","same again","0009" On Windows, In the second row, 3rd column Excel will remove the leading zeroes, if the file has an extension of .csv The same content in a file with the extension .txt is processed as csv, but without the removal of the leading zeroes from text values. This is value translation not formatting. Nightmare. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
