Brian Dunning's FileMaker Custom Functions

CustomValuesGreaterThan ( values ; reference ; valueFunction )

Values greater than reference, evaluated using a custom function

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

Richard Dyce   Richard Dyce
Dyce & Sons LTD.
http://dyce.com

Share on Facebook Share on Twitter

  Sample input:
CustomValuesGreaterThan ( "3,5¶4,2¶1,3¶4,1¶1,7¶2,0¶1,9" ; "4" ; "Middle( \"[t]\" ; Position( \"[t]\" ; \",\" ; -1 ; 1 ) + Length( \",\" ) ; 64000 )")
  Sample output:
"3,5¶1,7¶1,9"

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

CustomValuesGreaterThan ( values ; reference ; valueFunction ) returns a list of all values in list that are greater than the reference by comparing the first value determined using a custom function; then appending all other values greater than the reference with a recursive call to itself.

 

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.