If you're using an sql db: SELECT <thewordnumber>, count(*) AS C FROM <table> GROUP BY < thewordnumber > ORDER BY C DESCENDING
Returns the word numbers and count sorted by count high to low. Pete lcSQL Software On May 4, 2014 8:47 PM, "JOHN PATTEN" <johnpat...@me.com> wrote: > Thanks Kay! > > That’s what I needed. I knew it was pretty simple, but my unfamiliarity > with arrays prevented me from seeing the solution. > > Cheers! > > John Patten > SUSD > > On May 4, 2014, at 8:14 PM, Kay C Lan <lan.kc.macm...@gmail.com> wrote: > > > This might get you started, in the msg box: > > > > put "3,5,6,6,24,24,24,33,130,109" into tData > > --if the data comes from the db as seperate lines, then > > --repeat for each line tRecord in tData > > --if data comes in from db as a list > > repeat for each item tRecord in tData > > add 1 to aCount[tRecord] > > end repeat > > --now output results > > repeat for each key tKey in aCount > > put tKey & " = " & aCount[tKey] & cr after msg > > end repeat > > > > The output I get is: > > > > 109 = 1 > > 3 = 1 > > 130 = 1 > > 5 = 1 > > 33 = 1 > > 24 = 3 > > 6 = 2 > > > > HTH > > > > > > > > > > On Mon, May 5, 2014 at 10:58 AM, JOHN PATTEN <johnpat...@me.com> wrote: > > > >> Hi All… > >> > >> I am attempting to get the total number of times specific words in a > text > >> passage are selected by students. The way I’m doing this is by recording > >> the word numbers selected by each student and storing them in a > database. > >> I end up with list of numbers representing the selected words, something > >> like this: > >> 3 > >> 5 > >> 6 > >> 6 > >> 24 > >> 24 > >> 24 > >> 33 > >> 130 > >> 109 > >> … etc. etc. I would like to determine the number of times the same words > >> are selected by the students and then control their font size, make the > >> font size larger the more often the text is selected. So the teacher’s > >> report would be the same passage of text with the font sizes of the text > >> increased based on how many times the word was selected by the students. > >> > >> I’m not sure how to get the counts for the selected words. These list of > >> word numbers could be quite long, depending on how many students are in > the > >> class and the length of the passage. I have not done anything like this > >> before so I’m looking for any advice. Should I be dumping the list into > an > >> array and then working some kind of array magic? Can I just use a > repeated > >> find script and increment a variable for each item in my list? > >> > >> I didn’t want to spin my wheels too long, and this is probably pretty > >> basic, but I can’t remember coding a solution to something like this in > the > >> past. > >> > >> Thank you! > >> John Patten > >> SUSD > >> _______________________________________________ > >> use-livecode mailing list > >> use-livecode@lists.runrev.com > >> Please visit this url to subscribe, unsubscribe and manage your > >> subscription preferences: > >> http://lists.runrev.com/mailman/listinfo/use-livecode > >> > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode