Another idea might be to save it as seconds and then convert it to a date when the user needs to see the date. That way you would save the time converting all the dates in each sort.
JB > On Jul 10, 2020, at 9:02 PM, Tom Glod via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Yeah it will add some overhead, but it will work to do what you need. I'm > sorry I'm not fluent in the syntax of sort ..... but I knew you can specify > a date I never needed to use it.... I always store the seconds or > milliseconds. > > Yup.....Might as well convert to seconds and then sort numeric ascending or > descending. Its very fast in my experience. > > All the best. > > Tom > > On Fri, Jul 10, 2020 at 7:55 PM JB via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> If you are having problems with the date itself not being >> sorted properly you might be able to accomplish it by >> first converting the date to seconds and then sort the >> data. It will take more time but might work. >> >> JB >> >> >>> On Jul 10, 2020, at 3:06 PM, David V Glasgow via use-livecode < >> use-livecode@lists.runrev.com> wrote: >>> >>> Livecodeistas, >>> >>> I am working with text files consisting of many thousands of lines, most >> of which are in the format URL & Tab & Date - but a few don’t have a date. >>> >>> So they look like this ... >>> >>> http://1.lw6.blah/b7f3bd9e6b4d728a0f6d5883ed3a5ce/5326d47f?ss=152 >> 17/03/2014 9:55 >>> >> http://1.lw6.zdomain/storage/1/x/xk/xkwEp/encoded.mp4/7aecf5e57e34c5f9212f30d0ca16da5a/5326d454?ss=107 >> >>> >> http://1.lw6.zdomain/storage/1/x/xk/xkwEp/encoded.mp4/7aecf5e57e34c5f9212f30d0ca16da5a/5326d454?ss=107 >> >>> >> http://1.lw6.zdomain/storage/1/x/xk/xkwEp/encoded.mp4/7aecf5e57e34c5f9212f30d0ca16da5a/5326d454?ss=107 >> >>> http://adomain/ 27/06/2016 8:10 >>> http://adomain/ 27/06/2016 8:10 >>> http://adomain/ 27/06/2016 8:10 >>> http://adomain/ 27/06/2016 8:10 >>> >> http://adomain/?go=click&c=133&n=1&e=0&g=3&r=3841375&u=http%253A%252F%252Fadomain%somestuff-330835.html >> 17/11/2013 22:18 >>> >> http://adomain/?go=click&c=133&n=1&e=0&g=3&r=3841375&u=http%253A%252F%252Fadomain%somestuff-330835.html >> 17/11/2013 22:18 >>> >> http://adomain/?go=click&c=133&n=1&e=0&g=3&r=3841375&u=http%253A%252F%252Fadomain%somestuff-330835.html >> 17/11/2013 22:18 >>> >> http://adomain/?go=click&c=133&n=1&e=0&g=3&r=3841375&u=http%253A%252F%252Fadomain%somestuff-330835.html >> 17/11/2013 22:18 >>> >> http://adomain/?go=click&c=133&n=1&e=0&g=3&r=3841375&u=http%253A%252F%252Fadomain%somestuff-330835.html >> 17/11/2013 22:18 >>> >>> I assumed I could sort the lines by date using the following: >>> >>> set itemdel to tab >>> sort lines of field "import" datetime by the last item of each >>> >>> (I know I could speed this up using a variable, but I wanted to just see >> the result first.) >>> >>> I wasn’t sure what would happen to the lines with no date, but assumed >> they would pile up at the beginning or the end of the field (which would be >> fine). However, what happens is that the script runs, and the order above >> is generated. I can’t see any meaningful ordering of the lines. >>> >>> I have a horrible feeling that dates are more complicated than I >> imagined, although I am sort of hoping there something simple I just >> haven’t grasped. If so, what? >>> >>> Best wishes, >>> >>> David Glasgow >>> _______________________________________________ >>> 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 >> > > > -- > Tom Glod > Founder & Developer > MakeShyft R.D.A (www.makeshyft.com) > Mobile:647.562.9411 > _______________________________________________ > 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
