Filemaker Pro 8.5 Advanced Maintenance TG761Z/A Manual De Usuario
Los códigos de productos
TG761Z/A
186 FileMaker Functions Reference
Substitute
Format
Substitute(text;searchString;replaceString)
Parameters
text - any
searchString - any text expression or text field
replaceString - any text expression or text field
replaceString - any text expression or text field
Data type returned
text
Description
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
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:
example:
Substitute(text; [search1; replace1]; [search2; replace2]; ...
[searchN; replaceN])
[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
phrase
What you see is what you get
.
Substitute(text;[“a”;“A”];[“b”;“B”]) replaces every lowercase a or b with
A
or
B
.
Trim
Format
Trim(text)
Parameter
text - any
Data type returned
text