Filemaker TH325Z/A Fiche technique télécharger pdf (Page 180)

180 FileMaker Functions Reference

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

Description

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.

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.

Proper

Format

Proper(text)

Parameter

text - any text expression or text field

Data type returned

text

Description

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

lowercase.

Examples

Proper(“ABCD”) returns Abcd.

Proper(Name) returns Yumiko Kitagawa, when the Name field contains YUMIKO

KITAGAWA.

1 2 ... 175 176 177 178 179 180 181 182 183 184 185 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 180