Apps sqlite3 .import

[Rootstonian]

Having some problems:

1. Create 2 row ASCII text file as "testfile"
abc, def, ghi
jkl, mno, pqr

push it to emulator database directory. go into adb shell, navigate to databases directory and "cat" it.
PROBLEM ONE: I only see the last row, eg jkl, mno, pqr

2. create table "testtable" and run .import testfile testtable
PROBLEM TWO: works, but testtable has the data as "jkl", "mno", "pqr" -- why does is it insert data with the quotes (testfile has no quoted data!)

Thanks!

 

[Rootstonian]

ok, this is freaking weird...I just went back to the shell and selected the data...the quotes are GONE! what da hell. And I have a terminal session open that shows the 2 selects: one with quotes and know one without. Scary. Now just need to fix problem one...probably and end-of-line thang