Substitute
 
Purpose 
Returns a text string with every occurrence of searchString in specified text replaced by replaceString.
Format 
Substitute(text;searchString;replaceString)
Parameters 
text - any text expression or text field
searchString - any text expression or text field
replaceString - any text expression or text field
Data type returned 
text
Originated in 
FileMaker Pro 6.0 or earlier
Description 
This function is case-sensitive. Compare to the Replace function.
Multiple substitutions are allowed when you enclose each pair of searchString and replaceString parameters within 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(text; [search1; replace1]; [search2; replace2]; ... [searchN; replaceN])
Examples 
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.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.