Functions Reference

FILEMAKER FUNCTIONS REFERENCE 241
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
Contents
Functions reference (alphabetical list)
Trim
Purpose
Returns text stripped of all leading and trailing spaces.
Format
Trim(text)
Parameters
text - any text expression or text field
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Description
Use this function to remove unneeded spaces when you convert files from other programs or
systems that require a fixed number of characters per field, or to remove spaces accidentally typed
during data entry.
Examples
Trim(“ Tom ”) returns Tom.
Trim(Middle(“00230013 William 1234”;9;9)) returns William.
Related topics
Contents
Functions reference (alphabetical list)