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