On Sun, Jun 21, 2009 at 8:10 AM, Nicolas Cueto nicon...@gmail.com wrote:
My mistake (again), Kay. Your method
does work. The problem at my end
was my test-data, which included a
miscalculated leap year date of 2.29.09
-- an impossible date.
I'm fluent in mistakes as well :-) Much better
Tried it and, no, doesn't sort as expected.
Please explain further.
My mistake (again), Kay. Your method
does work. The problem at my end
was my test-data, which included a
miscalculated leap year date of 2.29.09
-- an impossible date.
Again, thank you.
--
Nicolas Cueto
On Fri, Jun 19, 2009 at 1:56 PM, Nicolas Cueto nicon...@gmail.com wrote:
Well, I found a solution. But maybe
someone's got something more
elegant.
How about:
replace . with / in tNaiyo
sort lines of tNaiyo ascending dateTime by word 2 of each
replace / with . in tNaiyo
HTH
How about:
replace . with / in tNaiyo
sort lines of tNaiyo ascending dateTime by word 2 of each
replace / with . in tNaiyo
Tried it and, no, doesn't sort as expected.
Thanks all the same.
--
Nicolas Cueto
___
use-revolution mailing list
)
--- On Thu, 6/18/09, Nicolas Cueto nicon...@gmail.com wrote:
From: Nicolas Cueto nicon...@gmail.com
Subject: sorting advice
To: How to use Revolution use-revolution@lists.runrev.com
Date: Thursday, June 18, 2009, 10:23 PM
Still avoiding thinking too much...
Given this list (a ref-number followed
Nicolas, this might a good case for using a custom sort like:
on mouseUp
put fld 1 into tData
sort lines of tData dateTime by toDate(word 2 of each)
put tData
end mouseUp
function toDate pStr
replace . with / in pStr
return pStr
end toDate
Best,
Mark Smith
On 19 Jun 2009, at
On Fri, Jun 19, 2009 at 4:26 PM, Nicolas Cueto nicon...@gmail.com wrote:
How about:
replace . with / in tNaiyo
sort lines of tNaiyo ascending dateTime by word 2 of each
replace / with . in tNaiyo
Tried it and, no, doesn't sort as expected.
Please explain further.
Using the data
Still avoiding thinking too much...
Given this list (a ref-number followed
by a dot-separated date):
bg2334 12.21.09
bg9788 1.10.02
bg6554 11.30.11
bg8902 6.6.04
bg4021 2.29.12
bg1210 1.2.02
bg3008 12.3.09
bg5526 5.29.04
what sort-command combo would
re-order it ascending by the date
to
Well, I found a solution. But maybe
someone's got something more
elegant.
Here's mine:
repeat for each line tLine in tNaiyo -- the list of data, unsorted
put word 2 of tLine word 1 of tLine cr after tSwitched
end repeat
delete the last char of tSwitched
put tSwitched