Brian Dunning's FileMaker Custom Functions

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

Fabrice Nordmann   Fabrice Nordmann

Share on Facebook Share on Twitter

  Sample input:
SubstituteManyWithCalculation ( "abcdef" ; "a¶c¶e" ; "_item" ; "TextStyleAdd ( _item ; bold )" )
  Sample output:
"abcdef" where a, c, and e are bold

  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 :



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.