Help

FILEMAKER PRO HELP 921
SerialIncrement(“abc12”;-1) returns abc11.
SerialIncrement(“abc12”;1.2) returns abc13.
SerialIncrement(“abc1.2”;1.2) returns abc1.3.
In the example below any character other than a number is considered as a separator and the
number on the far right is incremented.
SerialIncrement(“abc123;999”;1) returns abc123;1000.
Related topics
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Substitute
Purpose
Returns a text string with every occurrence of searchString in text replaced by
replaceString in text.
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 square brackets [ ] and separate them with semicolons.
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])