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?
>> _______________________________________________
>> 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
