If it's OK to use the sqlite3 cmd line shell then try this:
-- create test input table X
create table X (what text);
insert into X values ('abc,def');
-- write X to a file
.output mydata.csv
select * from X;
.output stdout
-- read it back in to parse it
create table Y (a text, b text);
.mode csv
.import mydata.csv Y
-- check Y - add a limit clause if Y is large
select * from Y;
On Wed, Jan 13, 2016 at 12:42 AM, audio muze <audiomuze at gmail.com> wrote:
> I have a table of roughly 500k records with a number of fields
> containing delimited text that needs to be parsed and written to
> separate tables as a master lists. In order to do this I need to
> parse the field contents, however, I don't see any functions within
> SQLite to enable that. The number of delimited entries embedded in a
> field can vary from none to as man as 20/30. Is there an addin I can
> compile with SQLite that provides the ability to parse a string?
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com
