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
kierencom
http://www.kierencom.ca

Sample input:

ListOperation ( "1 2 3 4" ; "+" )

Sample output:

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

Let
(
    [
        $formula = Substitute ( list ; [ ”¶” ; operator ] ; [ “ “ ; operator ] )
    ];

    Evaluate ( $formula )
)

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.

Comments

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

ListOperation ( list ; operator )

Comments

Support this website.

Support this website.