Filemaker Pro 8.5 Advanced Maintenance TG762Z/A User Manual

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.

number

Returns the starting position of the specified occurrence of searchString in text. If 
searchString isn’t contained in text or if there was no specified occurrence, zero is 

returned. The Position function is not case-sensitive.

Position(“Mississippi”;“iss”;1;1) returns 

.

Position(“Mississippi”;“iss”;1;2) returns 

.

Position(“Mississippi”;“iss”;3;1) returns 

.

Left(Name;Position(Name;“ “;1;1)-1) returns 

, when Name is a text 

field that contains William Smith.

Right(Name;Length(Name) - Position(Name;“ “;Length(Name);-1)) 

returns 

.

Proper(text)

text - any 

text

Returns the first letter of each word in text as uppercase and all other letters as 

lowercase.

Proper(“ABCD”) returns 

.

Proper(Name) returns 

, when the Name field contains YUMIKO 

KITAGAWA.