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] Parsing the contents of a field audio muze
- [sqlite] Parsing the contents of a field Edward Lau
- [sqlite] Parsing the contents of a field Simon Slavin
- [sqlite] Parsing the contents of a field Bart Smissaert
- [sqlite] Parsing the contents of a field Jim Morris
- [sqlite] Parsing the contents of a field Igor Korot
- [sqlite] Parsing the contents of a field Don V Nielsen
- [sqlite] Parsing the contents of a field Gabor Grothendieck
- [sqlite] Parsing the contents of a field audio muze
- [sqlite] Parsing the contents of a field Simon Slavin
- [sqlite] Parsing the contents of a field R Smith