Reference > Functions reference > Text functions > Substitute
 
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. Substitutions are performed in the order you specify, so one substitution may be further modified by subsequent substitutions. FileMaker supports up to 999 nested substitute conditions. 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