On Tue, 17 Jun 2008, Rich Shepard wrote: > 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.
Right, I realize the data should be normalized, but the data I have shown is how it arrives in the database from an external source. That data is my starting point, and I need to re-shape it for a specific need. I am just looking for some efficient syntax to do this re-shaping. Chris > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users