Sort question

Andre.Bisseret Andre.Bisseret at inria.fr
Mon Oct 4 03:18:11 EDT 2010


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 into fld "fld2" -- or fld1 as well of course

Best regards from Grenoble

André

Le 3 oct. 10 à 15:57, Yves COPPE a écrit :

> Hi list
>
> I have a list of lines
> each line has a first name & tab & a date (French format : DD/MM/YYYY)
>
> I want to sort the list on the DD/MM date without taking the YYYY  
> into account
>
> Here a sample :
>
> Jean	13/01/2017
> Luc	03/07/2017
> Bern	02/09/2015
> Michel	06/01/2018
> Bert	01/06/2016
> Jo	13/02/2016
> Rob	26/03/2018
> Nick	15/01/2015
>
> gives
>
> Michel	06/01/2018
> Jean	13/01/2017
> Nick	15/01/2015
> Jo	13/02/2016
> Rob	26/03/2018
> Bert	01/06/2016
> Luc	03/07/2017
> Bern	02/09/2015
>
> Can someone help me to to that ?
>
> Thanks.
>
> Amicalement.
>
> Yves COPPE
> yvescoppe at skynet.be
>
>
>
> Greetings.
>
> Yves COPPE
> yvescoppe at skynet.be
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution






More information about the use-livecode mailing list