Hi, On Wed, Jan 13, 2016 at 10:05 AM, Jim Morris <jimm at bearriver.com> wrote: > Might be doable with a recursive CTE > > On 1/13/2016 1:22 AM, Bart Smissaert wrote: >> >> 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?
You are way better off with a Perl script. Thank you. >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users at mailinglists.sqlite.org >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users