Brian Dunning's FileMaker Custom Functions

MinValue ( theList ; treatAsNumeric )

obtain the min value of a list WITHOUT RECURSION (thanks to Agnes Barouh and her "CustomList")

  Average rating: 4.4 (32 votes) Log in to vote

Benoit Jolly   Benoit Jolly
Active Développement
http://www.actived.fr

Share on Facebook Share on Twitter

  Sample input:
MinValue("65¶123¶21" ; 1 )


MinValue("65¶123¶21" ; 0 )


MinValue("zzz65¶aaa123¶ccc21" ; 1 )
  Sample output:
21


123


ccc21

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

// obtain the min value of a list WITHOUT RECURSION (thanks to Agnes Barouh and her "CustomList")
// theList : a list of values separated with ¶
// treatAsNumeric : request to handle each value as the "GetAsNumber()" of the value to be computed
//
//
// examples :
// MinValue("65¶123¶21" ; 1 ) => 21
// MinValue("65¶123¶21" ; 0 ) => 123 (because the text value of 123 is inferior to the text value of 21 in the alphabetical order)
// MinValue("zzz65¶aaa123¶ccc21" ; 1 ) => ccc21 (it does not take the letters into account for the comparison)
//

 

Comments

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.