AnsweredAssumed Answered

Documentation missing: maximum number of nested substitutes in Substitute() function

Question asked by MartinBrändle on Nov 13, 2009
Latest reply on Nov 16, 2009 by TSGal

Summary

Documentation missing: maximum number of nested substitutes in Substitute() function

Description of the issue

FileMaker Product(s) involved All FileMaker Pro and Advanced versions 7-10 Operating System(s) involvedall OS compliant with FM products given above Detailed description of the issue Tests show that at maximum 999 or 1000 nested substitutes seem to be possible in the Substitute() function: Substitute(field; ["s001";"r001"]; ["s002";"r002"]; ... ; ["s999";"r999"]) s001, r001 etc. are arbitrary search and replacement strings.  The size of the tested calculation function was smaller than 30'000 chars, so this limitation can be excluded.  This limit of the Substitute function is nowhere documented, neither in the Technical Specifications for FileMaker (http://www.thefmkb.com/7061) nor in the FM Help.   Expected ResultUpdate of FM Help or KB article 7061. Please confirm these limits here in the forum. Thank you.

Outcomes