Filemaker TH325Z/A Datenblatt PDF herunterladen (Seite 186)

186 FileMaker Functions Reference

Substitute

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

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

semicolons. 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.

Trim

Format

Trim(text)

Parameter

text - any text expression or text field

Data type returned

text

1 2 ... 181 182 183 184 185 186 187 188 189 190 191 ... 237 238

Keine Kommentare

Filemaker TH325Z/A Datenblatt Seite 186