sorting lines by date

[Tom Glod]

Hi David, you should be able to do this by specifying the sort-type. look
up 'sort container' in the dictionary.

On Fri, Jul 10, 2020 at 6:07 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
>


-- 
Tom Glod
Founder & Developer
MakeShyft R.D.A (www.makeshyft.com)
Mobile:647.562.9411