Hi:
Not sure what is the cost to first export the fields a flat file? Try https://github.com/elau1004/TFR4SQLite/wiki (may or may not fit your needs). It was intended to query flatfile with crazy delimiters, using SQLite query engine. If you can SELECT from a text file then you can insert the result into another table. Regards. -----Original Message----- From: audio muze <audiom...@gmail.com> To: sqlite-users <sqlite-users at mailinglists.sqlite.org> Sent: Tue, Jan 12, 2016 9:42 pm Subject: [sqlite] Parsing the contents of a field 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
