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 because I didn't think of the .separator command. However, in your case, having a space separate the columns is going to be pretty tricky. You can try something like sqlite3> .separator \s sqlite3> .import else, you might have to first change the space separator to something more definitive. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.ies.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------