Returns the number of occurrences of searchString in text.
PatternCount(text;searchString)text - any text expression or text field
searchString - any text expression or text field representing the set of characters you want to find
number
FileMaker Pro 6.0 or earlier
This function is not case sensitive. PatternCount begins at the start of text and counts each non-overlapping occurrence of searchString.
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.