Filemaker TH325Z/A Datový list stáhnout pdf (Strana 179)

Chapter 12

Text functions 179

Examples

NumToJText(123456789;2;0) returns

NumToJText(123456789;3;2) returns

PatternCount

Format

PatternCount(text;searchString)

Parameters

text - any text expression or text field

searchString - any text expression or text field representing the set of characters you

want to find

Data type returned

number

Description

Returns the number of occurrences of searchString in text.

Examples

PatternCount(“Mississippi”;“is”) returns 2.

PatternCount(“Mississippi”;“issi”) returns 1 (the function isn’t inclusive).

PatternCount(Attending;“Guest”) returns 1 if the Guest checkbox is one of the

items selected in the Attending field.

Position

Format

Position(text;searchString;start;occurrence)

Parameters

text - any text expression or text field

searchString - any text expression or text field representing the set of characters you

want to find.

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.

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

Žádné komentáře

Filemaker TH325Z/A Datový list Strana 179