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.