Re: sorting - THANK YOU PAUL!!

2014-08-09 Thread larry
Hi Paul, After trying MANY suggestions and my own trial and ERRORS, you finally provided me with a solution that actually works. I very much appreciate that you actually tested it. I have the feeling that many times in this list well-meaning people post solutions that they have not tested and

Re: sorting - THANK YOU PAUL!!

2014-08-09 Thread Paul Hibbert
You're more than welcome. I often see the problems posted here as challenges, some I have no chance with (they are way over my head), some I learn from other's answers, some I get totally wrong. Occasionally I see what I think may be a solution, but I usually have to do a test first to be sure

Re: sorting - THANK YOU PAUL!!

2014-08-09 Thread Colin Holgate
I tried Craig’s approach, but with the correct syntax, not the condensed example he gave. I put your example list into field 1, and had this script in a button: on mouseUp put fld 1 into fld 2 sort fld 2 by word 1 of each word 2 of each end mouseUp I then scrambled (manually) the lines

Re: sorting - THANK YOU PAUL!!

2014-08-09 Thread Paul Hibbert
Sorry, I did miss the numeric sort, it worked with a short example, but using Colin's test script, this also works: on mouseUp sort lines of fld sortField numeric by word 2 of each sort lines of fld sortField descending by word 1 of each end mouseUp Paul On 2014-08-09, at 9:51 AM, Colin