On 10/25/2013 3:11 PM, Joe.Fisher wrote:
Is it possible to import data by column number without using any
delimiters?
We have massive text based data files where each record of the data is
segmented and consistent (Col 1-3, 4-9, 10-12, etc.).
I've never had experience importing without some delimiter.
Import into a table with a single text column, then do something like
insert into RealTable(field1, field2)
select substr(rawText, 1, 3), substr(rawText, 4, 6)
from RawTextTable;
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users