Filemaker Pro 8.5 Advanced Maintenance TG762Z/A User Manual

Substitute(text;searchString;replaceString)

text - any 

searchString - any text expression or text field
replaceString - any text expression or text field

text

Returns a text string with every occurrence of searchString in text replaced by 
replaceString in text.
The Substitute function is case-sensitive. Compare to the Replace function.
Multiple substitutions are allowed when you enclose each pair of searchString and 
replaceString parameters within square brackets [ ] and separate them with 

semicolons. Each search and replace list item is also separated by semicolons. For 
example:

Substitute(text; [search1; replace1]; [search2; replace2]; ... 
[searchN; replaceN])

Substitute(Description;“WYSIWYG.”;“What you see is what you get”) 

replaces every occurrence of the acronym “WYSIWYG.” in the Description field with the 
phrase 

.

Substitute(text;[“a”;“A”];[“b”;“B”]) replaces every lowercase a or b with 

 

or 

.

Trim(text)

text - any 

text