SubstituteManyWithCalculation ( _text ; _list ; _varName ; _expression )
Substitutes many terms in a text and apply a calculation to them.
Average rating: 4.2 (34 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Substitutes every item of _list in _text, while applying a calculation to the item.
UPDATE : I would now recommend the use of CustomList, by Agnès Barouh : http://www.briandunning.com/cf/747
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.