SQLite Forum

Unstack one column to multiple
Login
I would readfile() first the text into a table with a clob field (character large object), so you can use substr() from the Text. Then search for line breaks with a „with recursive“ Statement. That will help to break the Text into records. Use the found size in one line to get the Start for the next. You can use the window clause to get the Last Start and size. Instr() looks for the next cr lf cr lf then as record termination.
Finally you can Process each record Looking up keywords. You can get help from replace functions also.