searchString - any text expression or text field
replaceString - any text expression or text field
Multiple substitutions are allowed when you enclose each pair of searchString and
replaceString parameters within square brackets [ ] and separate them with semicolons. FileMaker supports up to 999 nested substitute conditions. Each search and replace list item is also separated by semicolons. For example:
Substitute(Description;“WYSIWYG.”;“What you see is what you get.”) replaces every occurrence of the acronym “WYSIWYG.” in the Description field with the phrase
What you see is what you get.
Substitute(text;[“a”;“A”];[“b”;“B”]) replaces every lowercase a or b with
A or
B.