Brian Dunning's FileMaker Custom Functions

ListSort ( ValueList )

Sort of a (short) list without subfunctions (recursive)

  Average rating: 3.5 (2 votes) Log in to vote

Theo Tromp   Theo Tromp
XS Consultants
http://www.xs.nl

Share on Facebook Share on Twitter

  Sample input:
ListSort ( 3
2
1 )
  Sample output:
1
2
3

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

The list is sorted

 

Comments

Lee Smith   Lee Smith
Aug 25, 2017
Your CF is looking fore _ListSort ?
 
Theo   Theo, lelystad
Aug 26, 2017
Oeps, I renamed _ListSort to ListSort but forgot the references....
 
Huib   Huib, Amsterdam
Dec 30, 2017
Hallo Theo,

10
1
2
sorts as
1
10
2
instead of
1
2
10
the calculation field is set on number
or did I applied your function wrongly?

ps: denk dat ik in het NL had kunnen schrijven..
 
Theo Tromp   Theo Tromp, Lelystad
Dec 30, 2017
Ja Huib, het is een alfabetische sort.
Is niet aangegeven, dat is niet zo netjes.
Theo

In English:
The function is sorting alphabetical order. So numbers are treated als strings also.
Theo
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.