sqlite has this rather nice function called group_concat, which works like this:
$ sqlite3 test.db .dump
BEGIN TRANSACTION;
CREATE TABLE foo (foo, bar);
INSERT INTO "foo" VALUES('a','1');
INSERT INTO "foo" VALUES('a','2');
INSERT INTO "foo" VALUES('a','3');
INSERT INTO "foo" VALUES('a','4');
INSERT INTO "foo" VALUES('a','5');
INSERT INTO "foo" VALUES('b','1');
INSERT INTO "foo" VALUES('b','2');
INSERT INTO "foo" VALUES('b','3');
INSERT INTO "foo" VALUES('b','4');
INSERT INTO "foo" VALUES('b','5');
COMMIT;
$ sqlite3 -header -column test.db 'select foo, group_concat(bar) from
foo group by foo ; '
foo group_concat(bar)
---------- -----------------
a 1,2,3,4,5
b 1,2,3,4,5
I was almost positive that OpenOffice's Calc had a similar feature
with its Data Pilot feature (aka Pivot Table), but I can't seem to
find it. Was I mistaken or is it in a newer verison of OpenOffice
that I'm not using right now (using Ubuntu 7.10 with OOo 2.3)?
Regards,
- Robert
--~--~---------~--~----~------------~-------~--~----~
Central West End Linux Users Group (via Google Groups)
Main page: http://www.cwelug.org
To post: [email protected]
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
More options: http://groups.google.com/group/cwelug
-~----------~----~----~----~------~----~------~--~---
