Re: [sqlite] Importing csv to SQLite

2010-09-14 Thread Konrad J Hambrick
Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 09/13/2010 04:06 PM, BareFeetWare wrote: >> All this talk of replacing multiple commas with pipes, then replacing pipes >> and so on, though clever and helpful is problematic, cumbersome and even >> comical for a matur

Re: [sqlite] Importing csv to SQLite

2010-09-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/13/2010 04:06 PM, BareFeetWare wrote: > All this talk of replacing multiple commas with pipes, then replacing pipes > and so on, though clever and helpful is problematic, cumbersome and even > comical for a mature product like SQLite. SQLite i

Re: [sqlite] Importing csv to SQLite

2010-09-13 Thread Konrad J Hambrick
BareFeetWare wrote: > All this talk of replacing multiple commas with pipes, then replacing pipes > and so on, though clever and helpful is problematic, cumbersome and even > comical for a mature product like SQLite. > > On 13/09/2010, at 9:53 PM, Simon Slavin wrote: > >> This is true. You a

Re: [sqlite] Importing csv to SQLite

2010-09-13 Thread BareFeetWare
All this talk of replacing multiple commas with pipes, then replacing pipes and so on, though clever and helpful is problematic, cumbersome and even comical for a mature product like SQLite. On 13/09/2010, at 9:53 PM, Simon Slavin wrote: > This is true. You are right. You might argue that it'

Re: [sqlite] Importing csv to SQLite

2010-09-13 Thread Konrad J Hambrick
Rich Shepard wrote: On Mon, 13 Sep 2010, Mithun Nair wrote: When i try importing it into a SQLite table, i get some errors like "expected 2 columns of data but found 1". Later i found that importing a comma separated file into SQlite wont work because a comma is considered as a delimiter by t

Re: [sqlite] Importing csv to SQLite

2010-09-13 Thread Rich Shepard
On Mon, 13 Sep 2010, Mithun Nair wrote: > When i try importing it into a SQLite table, i get some errors like > "expected 2 columns of data but found 1". Later i found that importing a > comma separated file into SQlite wont work because a comma is considered > as a delimiter by the the SQLite en

Re: [sqlite] Importing csv to SQLite

2010-09-13 Thread Simon Slavin
On 13 Sep 2010, at 11:53am, Mithun Nair wrote: > Its a comma separated file. > When i try importing it into a SQLite table, i get some errors like "expected > 2 columns of data but found 1". Later i found that importing a comma > separated file into SQlite wont work because a comma is considere