Functions Reference

FILEMAKER FUNCTIONS REFERENCE 240
If the incrementBy value is a decimal number, then only the integer portion of incrementBy
value is added to the last number in
text. Any character other than a number is considered a
separator. You can use both positive and negative
incrementBy values.
Examples
SerialIncrement(“abc12”;1) returns abc13.
SerialIncrement(“abc12”;7) returns abc19.
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
Contents
Functions reference (alphabetical list)
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.