Brian Dunning's FileMaker Custom Functions

ListOperation ( list ; operator )

Apply a mathematical operation to every value in a (text) list.

  Average rating: 4.2 (29 votes) Log in to vote

Kieren MacMillan   Kieren MacMillan

Share on Facebook Share on Twitter

  Sample input:
ListOperation ( "1 2 3 4" ; "+" )
  Sample output:

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

Substitutes the supplied mathematical operator for spaces and hard returns -- modifiable for other substitutions, of course -- and evaluates the resulting formula. Great for adding or multiplying a list of numbers.

Note: does not error check for leading/trailing spaces or returns -- use my "TrimCharacter" function to handle such cases.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.