You will thank yourself by using a scripting language such Ruby, php, or python.
Is there a reg ex library for sqlite that could be employed? On Tue, Jan 12, 2016 at 11:42 PM, 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 >
