Functions Reference

FILEMAKER FUNCTIONS REFERENCE 233
start - any numeric expression, or field containing a number, representing the number of
characters from the start of the text string at which to begin the search.
occurrence - any numeric expression or field containing a number, representing which instance of
the text string you want to find. A negative occurrence value causes the scan to go in the opposite
direction from start. A zero value for occurrence is invalid and returns a result of zero.
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Description
This function is not case-sensitive. If searchString isn’t contained in text or if there was no
specified occurrence, zero is returned.
Examples
Position(“Mississippi”;“iss”;1;1) returns 2.
Position(“Mississippi”;“iss”;1;2) returns 5.
Position(“Mississippi”;“iss”;3;1) returns 5.
Left(Name;Position(Name;“ “;1;1)-1) returns William, when Name is a text field that
contains William Smith.
Right(Name;Length(Name) - Position(Name;“ “;Length(Name);-1)) returns Smith.
Related topics
Contents
Functions reference (alphabetical list)
Proper
Purpose
Returns the first letter of each word in text as uppercase and all other letters as lowercase.
Format
Proper(text)
Parameters
text - any text expression or text field
Data type returned
text