PatternCount
Purpose
Returns the number of occurrences of searchString in text.
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
Originated in
FileMaker Pro 6.0 or earlier
Description
This function is not case-sensitive.
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.
PatternCount(Get(AccountPrivilegeSetName);"Guest") returns 0 if the current account has the Full Access privilege set.
Related topics