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
1-more-thing
https://www.1-more-thing.com

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 : http://www.briandunning.com/cf/747

 

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.