Re: [sqlite] Shell tool improvement request

2015-01-16 Thread Nelson, Erik - 2
RSmith wrote on Friday, January 16, 2015 1:08 PM > > On 2015/01/16 18:33, Simon Slavin wrote: > > > > Error: mytextfile.txt line 13588392: expected 2 columns of data but > > found 1 > > > > Naturally I spent some time looking near the end of the file to > figure out what was wrong where the actual

Re: [sqlite] Shell tool improvement request

2015-01-16 Thread RSmith
On 2015/01/16 18:33, Simon Slavin wrote: (following description simplified) I have a text file I wanted to .import into a table. The text file has two columns separated by a tab: a word and a number. It starts off like this: ! 32874624 " 239874242 # 98235252 $ 438743824 %

[sqlite] Shell tool improvement request

2015-01-16 Thread Simon Slavin
(following description simplified) I have a text file I wanted to .import into a table. The text file has two columns separated by a tab: a word and a number. It starts off like this: ! 32874624 " 239874242 # 98235252 $ 438743824 % 324872489 & 39854724 a