On Fri, Apr 30, 2010 at 10:17 AM, Gerry Snyder <mesmerizer...@gmail.com> wrote: > So why not columns keyword and value? >
because, each row is a conceptual "text file" with many key-value combos. Putting them in separate rows would mean that each key-val belongs in a separate text file, whatever that text file represents. That is not what the OP wants. > Gerry > > On 4/30/10, David Lyon <david_ly...@yahoo.com> wrote: >> Thanks for everyones efforts let me expand: >> >> >> if I had many many files like this: >> http://research.stowers-institute.org/efg/ScientificSoftware/Utility/FCSExtract/CC4_067_BM.txt >> >> you see 2 columns keyword and value, the keywords would be the fields (1st >> column in the html link above) in the table while the values (second column) >> are the data I would insert. >> >> The fields will be many and include >> >> P$nR >> P$nS >> P$nB >> >> etc. >> >> thats why I wanted a quick way to access "select P%R from TABLE"; >> >> >> thanks again >> >> >> >> >> >> >> >> >> >> >> >> >> >> ----- Original Message ---- >> From: P Kishor <punk.k...@gmail.com> >> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >> Sent: Fri, April 30, 2010 10:48:41 AM >> Subject: Re: [sqlite] select %column% from table >> >> crap! I completely misunderstood your question... be confused, and >> then ignore my reply. >> >> On Fri, Apr 30, 2010 at 9:43 AM, P Kishor <punk.k...@gmail.com> wrote: >>> On Fri, Apr 30, 2010 at 9:28 AM, David Lyon <david_ly...@yahoo.com> wrote: >>>> If I had a table called TABLE with fields P1N......P50N is there a way to >>>> select something like: >>>> >>>> "select P%N from TABLE" >>>> >>>> to return all the results from columns P1N......P50N or do I have to do >>>> it manually: >>>> >>>> "select P1N, P2N, P3N, P$nN from TABLE" >>>> >>> >>> use GLOB. See below >>> >>> Last login: Wed Apr 28 09:42:46 on console >>> punk...@lucknow ~$sqlite3 >>> -- Loading resources from /Users/punkish/.sqliterc >>> SQLite version 3.6.23 >>> Enter ".help" for instructions >>> Enter SQL statements terminated with a ";" >>> sqlite> CREATE TABLE t(a); >>> sqlite> INSERT INTO t VALUES ('P1N'); >>> sqlite> INSERT INTO t VALUES ('P3N'); >>> sqlite> INSERT INTO t VALUES ('P30N'); >>> sqlite> INSERT INTO t VALUES ('P303N'); >>> sqlite> INSERT INTO t VALUES ('P303X'); >>> sqlite> INSERT INTO t VALUES ('P30Z'); >>> sqlite> SELECT * FROM t; >>> a >>> ---------- >>> P1N >>> P3N >>> P30N >>> P303N >>> P303X >>> P30Z >>> sqlite> SELECT * FROM t WHERE a GLOB 'P*N'; >>> a >>> ---------- >>> P1N >>> P3N >>> P30N >>> P303N >>> sqlite> >>> >>> >>>> I can obviously do it via scripting but wanted a more elegant way. >>>> >>>> Thanks for your help in advance. >>>> >>>> >>>> >>>> _______________________________________________ >>>> sqlite-users mailing list >>>> sqlite-users@sqlite.org >>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>>> >>> >>> >>> >>> -- >>> Puneet Kishor http://www.punkish.org >>> Carbon Model http://carbonmodel.org >>> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org >>> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor >>> Nelson Institute, UW-Madison http://www.nelson.wisc.edu >>> ----------------------------------------------------------------------- >>> Assertions are politics; backing up assertions with evidence is science >>> ======================================================================= >>> >> >> >> >> -- >> Puneet Kishor http://www.punkish.org >> Carbon Model http://carbonmodel.org >> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org >> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor >> Nelson Institute, UW-Madison http://www.nelson.wisc.edu >> ----------------------------------------------------------------------- >> Assertions are politics; backing up assertions with evidence is science >> ======================================================================= >> _______________________________________________ >> 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 >> > > -- > Sent from my mobile device > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users