Thanks everyone & Curry. I will play with this some more. Looking at the
lists I am given, most of the date columns are declared to be UTC. I intended
to try to detect other formats in due course, but thought I’d start with the
common one.
Reminds me of my favourite Jake Peralta line: “Stupi
Like everything field and text related, this thread caught my eye! :)
One of my favorite areas of LiveCode, and also one of the areas I have
to actively keep an eye on since I rely on it a lot.
Here's an observation that might help in one way or another
David:
> http://adomain/27/06
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
> wrote:
>
> Yeah it will add some overhead, but
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 asce
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
> wrote:
>
>
Hi Tom,
That’s what I thought I was doing. From the dictionary…
The dateTime keyword recognizes all LiveCode's date and time formats and sorts
them in time order, rather than alphabetical or numeric order.
Cheers,
David G
> On 10 Jul 2020, at 11:24 pm, Tom Glod via use-livecode
> wrote:
>
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@lists.runrev.com> wrote:
> Livecodeistas,
>
> I am working with text files consisting of many thousands
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.zdo
