Re: [sqlite] how to ".import" an Ascii file

2006-08-29 Thread Randall
Sorry for the false info Ascii files have 3 character separation, including 2 chr(34 )(quote)=with space between [" "] ; that is my problem! Best, Randall; thanks for your patience. - To unsubscribe, send email to [

RE: [sqlite] how to ".import" an Ascii file

2006-08-29 Thread Griggs, Donald
Hi Randall, Regarding: how to ".import" an Ascii file (separator is " ") Assuming that no translations have occurred in transit, it looks as though you're using a single ascii space as a separator. So, given a file such as: cat dog koala bananna orange kiwi You should be able to import it us

Re: [sqlite] how to ".import" an Ascii file

2006-08-29 Thread P Kishor
On 8/29/06, Randall <[EMAIL PROTECTED]> wrote: Hi, I feel embarrased after searching the archives and syntax; Can anyone pleasae spare the time to teach me how to ".import" an Ascii file (separator is " ") I cannot get the separator to work. Many Thanks, Randall I had the toughest time myself