It probably can be done with just SQLite's built-in text functions such as instr and substr, although with 20 to 30 items it may get a bit messy and complex.
RBS On Wed, Jan 13, 2016 at 5: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 >