I would change the first line below and add one line and one parameter(dateTimeColumn). This assumes that the date/time is converted into seconds or milliseconds).
add 1 to uNames[item pColumn of l]["Count"] if item dateTimeColumn of l > uNames[item pColumn of l]["DateTime"] then put item dateTimeColumn of l into uNames[item pColumn of l]["DateTime"] Then the returned array will still have the keys of all unique drivers and each key will have 2 keys "Count" and "Datetime" Ralph DiMola IT Director Evergreen Information Services [email protected] -----Original Message----- From: use-livecode [mailto:[email protected]] On Behalf Of Skip Kimpel via use-livecode Sent: Monday, April 27, 2020 3:29 PM To: How to use LiveCode Cc: Skip Kimpel Subject: Re: Counting unique items in a file All of that works perfectly. Thank you everybody! Let's through a layer of complexity in here... each of of those names has another column with a time associated with it, for instance "13:02:58" I would like to only show the LATEST time associated with that particular name. Premise behind this whole exercise: I have a list of drivers and I want to produce a report that shows the driver name, number of jobs (both of these accomplished through the last script) and when they finished their last delivery. Should I just break this out into a separate function or would it make sense to modify this function to fit these additional needs? SKIP On Mon, Apr 27, 2020 at 3:05 PM Skip Kimpel <[email protected]> wrote: > Silly me... of course. Thank you, Dunbarx for pointing out the > obvious :) > > SKIP > > On Mon, Apr 27, 2020 at 2:27 PM dunbarx--- via use-livecode < > [email protected]> wrote: > >> Hi. >> You are getting empty because the information returned from the >> function is an array. >> "combine " the array with "return and "comma" >> Craig >> >> >> -----Original Message----- >> From: Skip Kimpel via use-livecode <[email protected]> >> To: Dan Friedman <[email protected]> >> Cc: Skip Kimpel <[email protected]>; How to use LiveCode < >> [email protected]> >> Sent: Mon, Apr 27, 2020 1:52 pm >> Subject: Re: Counting unique items in a file >> >> Thanks Dan! >> >> Upon very quick implementation, I am getting empty results back. I >> think I need to play around with this a little bit more but I feel >> you got me on the right track. >> >> Thanks again, >> >> SKIP >> >> On Mon, Apr 27, 2020 at 1:34 PM Dan Friedman >> <[email protected]> >> wrote: >> >> > Skip, >> > >> > Haven't tested, but pope about this... >> > >> > function getUniqueNames inData,pColumn put "" into uNames set the >> > itemDel to tab repeat for each line l in inData >> > add 1 to uNames[item pColumn of l] end repeat >> > >> > return uNames >> > end getUniqueNames >> > >> > You should get back an array keyed by the unique names, and how >> > many instances of each one >> > >> > >> > -Dan >> > >> > >> > >> > On 4/27/20, 10:25 AM, "use-livecode on behalf of Skip Kimpel via >> > use-livecode" <[email protected] on behalf of >> > [email protected]> wrote: >> > >> > Good afternoon LC'ers, >> > >> > I am loading a tab delimited file into a variable and I need to >> > pull out >> > all unique names from a certain column (let's say column 10) and >> count >> > how >> > many times that name appears in that column. >> > >> > I know there has to be an easy way of doing it. Every time I >> > try to start >> > coding this it get waaaayyy too long :) >> > >> > Simple approach? >> > >> > SKIP >> > _______________________________________________ >> > use-livecode mailing list >> > [email protected] >> > Please visit this url to subscribe, unsubscribe and manage your >> > subscription preferences: >> > http://lists.runrev.com/mailman/listinfo/use-livecode >> > >> > >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
