This does a stable sort as required. One sort line.
on mouseUp
put yourData into temp
set the itemdel to "/"
sort lines of temp numeric by item 2 of each & char -2 to -1 of item 1
of each
answer temp
end mouseUp
It cheats a bit in that it expects the data to be in a format it li
Hi,
I finally had a chance to check it. "And" won't work indeed. You need to use
two subsequent sort commands (I know this has been discussed already, I just
want to avoid any confusion).
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://eco
Le 4 oct. 10 à 09:18, Andre.Bisseret a écrit :
Bonjour Yves,
I propose this one:
put fld "fld1" into tText
replace slash with space in tText
set the itemDel to tab
sort lines of tText ascending numeric by word 1 of item 2 of each
sort lines of tText ascending numeric by word 2 of item 2 of ea
Bonjour Yves,
I propose this one:
put fld "fld1" into tText
replace slash with space in tText
set the itemDel to tab
sort lines of tText ascending numeric by word 1 of item 2 of each
sort lines of tText ascending numeric by word 2 of item 2 of each
replace space with slash in tText
put tText int
Oops, that's the iPhone. I meant: won't always work correctly. You need to use
'and' and sort numeric.
--
Kind regards,
Mark Schonewille
Economy-x-Talk
Http://economy-x-talk.com
Share the clipboard of your computer over a local network with Clipboard Link
http://clipboardlink.economy-x-talk.co
On 03/10/2010 15:39, Colin Holgate wrote:
Ben, wouldn't yours just end up with it sorted the second way?
Mark's does work if you use&
No, because Rev doesn't move lines if they have the same value on the sort
expression. So two sort commands in succession have the desired effect - the
first
On Oct 3, 2010, at 11:08 AM, Mark Schonewille wrote:
> && won't always workshop corrector. Probably you neef to use 'and' and sort
> numeric.
I think your spell checker doesn't alway walk correctly either.
___
use-revolution mailing list
use-revol
Hi,
&& won't always workshop corrector. Probably you neef to use 'and' and sort
numeric.
--
Kind regards,
Mark Schonewille
Economy-x-Talk
Http://economy-x-talk.com
Share the clipboard of your computer over a local network with Clipboard Link
http://clipboardlink.economy-x-talk.com
Op 3 okt.
Le 03-oct.-10 à 16:49, Colin Holgate a écrit :
ok
thank you
Greetings.
Yves COPPE
yvesco...@skynet.be
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
pr
Le 03-oct.-10 à 16:47, Jim Ault a écrit :
use word -1 of item 1 of blahblah
to get the last word
ok
thank you
Greetings.
Yves COPPE
yvesco...@skynet.be
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to
On Oct 3, 2010, at 10:43 AM, Yves COPPE wrote:
>
> some first names have 2 words !!!
>
Go back to using Mark's way, with & instead of 'and', and also say 'last word
of each' instead of 'word 2 of each'.
___
use-revolution mailing list
use-revolu
use word -1 of item 1 of blahblah
to get the last word
On Oct 3, 2010, at 7:43 AM, Yves COPPE wrote:
Le 03-oct.-10 à 16:32, Ben Rubinstein a écrit :
This is really the same as Mark suggested, but should work even if
the numbers aren't zero padded:
function sortByMonthAndDay tText
set
Le 03-oct.-10 à 16:32, Ben Rubinstein a écrit :
This is really the same as Mark suggested, but should work even if
the numbers aren't zero padded:
function sortByMonthAndDay tText
set the itemDelimiter to "/"
sort lines of tText ascending numeric by item 1 of (word 2 of each)
sort line
Le 03-oct.-10 à 16:32, Ben Rubinstein a écrit :
This is really the same as Mark suggested, but should work even if
the numbers aren't zero padded:
function sortByMonthAndDay tText
set the itemDelimiter to "/"
sort lines of tText ascending numeric by item 1 of (word 2 of each)
sort line
Changing the first suggestion
set the itemDel to slash
sort lines of myList by item 2 of (word 2 of each) and item 1 of (word 2 of
each)
to
set the itemDel to slash
sort lines of myList by item 2 of (word 2 of each) *&&* item 1 of (word 2 of
each)
works for this also as long as the data is alwa
Ben, wouldn't yours just end up with it sorted the second way?
Mark's does work if you use &
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
htt
Le 03-oct.-10 à 16:31, Jim Ault a écrit :
Use the technique of sorting by a function call for each line to set
a value.
on testSort
put the clipboarddata into theListOfFriends
sort theListOfFriends numeric ascending by sortByThisValue(each)
;put theListOfFriends
end testSort
function
This is really the same as Mark suggested, but should work even if the numbers
aren't zero padded:
function sortByMonthAndDay tText
set the itemDelimiter to "/"
sort lines of tText ascending numeric by item 1 of (word 2 of each)
sort lines of tText ascending numeric by item 2 of (word 2
Use the technique of sorting by a function call for each line to set a
value.
on testSort
put the clipboarddata into theListOfFriends
sort theListOfFriends numeric ascending by sortByThisValue(each)
;put theListOfFriends
end testSort
function sortByThisValue singleLineOfList
set
I think that just missed the year...
On Sun, Oct 3, 2010 at 10:14 AM, Yves COPPE wrote:
>
> Le 03-oct.-10 à 16:04, Mark Schonewille a écrit :
>
>
> Hi Yves,
>>
>> What about this:
>>
>> set the itemDel to slash
>> sort lines of myList by item 2 of (word 2 of each) and item 1 of (word 2
>> of ea
Le 03-oct.-10 à 16:04, Mark Schonewille a écrit :
Hi Yves,
What about this:
set the itemDel to slash
sort lines of myList by item 2 of (word 2 of each) and item 1 of
(word 2 of each)
Re,
No, I don't receive the right answer
it gives :
Jean13/01/2017
Luc 03/07/2017
Bern02
Hi Yves,
What about this:
set the itemDel to slash
sort lines of myList by item 2 of (word 2 of each) and item 1 of
(word 2 of each)
--
Economy-x-Talk
Consultancy and Software Engineering
http://economy-x-talk.com
http://www.salery.biz
Get your store on-line within minutes with Salery Web
Hi list
I have a list of lines
each line has a first name & tab & a date (French format : DD/MM/)
I want to sort the list on the DD/MM date without taking the into
account
Here a sample :
Jean13/01/2017
Luc 03/07/2017
Bern02/09/2015
Michel 06/01/2018
Bert01/06/2016
On 3/6/06 1:49 PM, "J. Landman Gay" <[EMAIL PROTECTED]> wrote:
> Jim Ault wrote:
>> Sorting by another field. Parallel sort question
>> Is there an easy syntax for using the sort lines to do parallel sorting
>
> There is nothing built-in, but I've
Jim Ault wrote:
Sorting by another field.
Parallel sort question
Is there an easy syntax for using the sort lines to do parallel sorting
There is nothing built-in, but I've used this:
local lKeyData, lLineCounter
on sortBy keyField -- parallel sorting of linked flds
put fld keyField
Sorting by another field.
Parallel sort question
Is there an easy syntax for using the sort lines to do parallel sorting
I know how to :
sort lines of fld dataLines descending by the number of items of each
and
--using a function call to define the sortKey value (value sorted on)
sort lines of
Gregory Lypny wrote:
Hello everyone,
I have a simply twelve-line list with the name of a month as the
first word on each line. The list is not in order, and I'd like to
sort it January to December using the monthNames. Don't know how.
sort lines of theList by first word in ea
Gregory, you can use functions as part of your sort command, like this:
on mouseUp
sort lines of fld 1 numeric by getMonthNum(word 1 of each)
end mouseUp
function getMonthNum aMonth
return lineOffset(aMonth,the monthNames)
end getMonthNum
Cheers,
Mark
On 18 Oct 2005, at 17:04, Gregory L
Hi Gregory,
Hello everyone,
I have a simply twelve-line list with the name of a month as
the first word on each line. The list is not in order, and I'd
like to sort it January to December using the monthNames. Don't
know how.
sort lines of theList by first word in each [need
Hello everyone,
I have a simply twelve-line list with the name of a month as the
first word on each line. The list is not in order, and I'd like to
sort it January to December using the monthNames. Don't know how.
sort lines of theList by first word in each [need connection
Yes, Wouter, you are right. Your sort result is true and exactly correct,
given the data source. I am also on a Mac, but that should make absolutely
no difference.
First four sorted values in the output list are
> 10.101-
> 11.151-
> 4.101-
> 5.101.1-
which a TEXT sort, because there is a trail
On 03 Jun 2005, at 20:09, Jim Ault wrote:
Greetings, jack
snip
on sortFldSource
put fld "source" into tSource --lines to sort
sort lines of tSource numeric by numberConvert(each)
put tSource into fld "destination" --output for your review
end sortFldSource
function numberConvert p
Jack,
1. Open a new stack, place 2 scrolling fields and 1 button "Modify_Sort" on it
2. Copy (cut & paste) your data into fld 1 - must be 1 number/line
3. Copy the following script into your "Midify_Sort" button
on mouseUp -- by Ralph forehand 06/03/05
-- inset leading 0s into numers where
gt; From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jim Ault
> Sent: Friday, June 03, 2005 20:10
> To: How to use Revolution
> Subject: Re: sort question
>
> Greetings, jack
>
> First point is that these are not numbers, so numeric has no meaning.
> Th
Greetings, jack
First point is that these are not numbers, so numeric has no meaning.
These are text strings and are sorted as such.
You also have some lines with trailing spaces. You need to clean these up
some how to make the sorting work as you wish.
Try converting these strings to a number f
Hi Jack,
You could do for example:
on mouseUp
get field 1
sort it
set the itemdelimiter to "."
sort lines of it numeric ascending by item 1 of each
put it into fld 2
end mouseUp
Greetings,
Wouter
On 03 Jun 2005, at 18:45, [EMAIL PROTECTED] wrote:
Greetings,
I need a field to sor
Greetings,
I need a field to sort numerically and when I try it I get the result below. I
checked the docs and experimented with the numberformat without success. Help!
jack
1.101-
10.101-
10.201-
10.301.1-
10.351-
10.401-
10.501-
11.101.1-
11.151-
2.101-
2.301-
20.101-
3.101-
4.101-
37 matches
Mail list logo