sorting lines by date

[Tom Glod]

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 at 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 at 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 at 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 at 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