On Tue, 17 Jun 2008, [EMAIL PROTECTED] wrote: > As shown, ITEMS is comprised of individual data items separated by > semicolons. For some purposes, this concatenated form suits the purpose, > but for other purposes I need to split these items into individual data > points. That is, I want to split the ITEMS (at the semicolons) into > separate rows in a new table FOO2, having fields ID and SINGLEITEM that > looks like this: > > ID, SINGLEITEM > 1,item1 > 1,item2 > 1,item3 > 2,item1 > 2,item4 > 3,item5 > 3,item3 > 3,item7 > > Any suggestions of how to do this in SQLite?
Chris, You ought to normalize your data. Consider (and this is just off the top of my head) two tables: one to hold categories and their descriptions, the other to hold categories and items. Then you can select either specific items, all items, or groups of items collected as you wish. Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
