Syntax: PatternCount ( text; searchString )
textAny expression that resolves to a text string.
searchStringAny expression that resolves to a text string, representing the substring for which you want to search within the text string.
Data type returned: Number
Returns the number of times that searchString appears in the text string. PatternCount() returns 0 if the searchString is not found.
Only non-overlapping occurrences of searchString are counted by PatternCount(). PatternCount() is not case sensitive.
Even though PatternCount() is designed to answer the question "how many?", it is often used simply to determine whether one string is contained within another. If it returns any value other than zero, the search string is found.
PatternCount ("This is a test"; "is")
PatternCount (WindowNames; "¶") + 1
Returns the number of carriage returns in the list returned by the WindowNames() function. This could be used to determine the number of windows that are available. The ValueCount() function could also be used for this purpose.
PatternCount ("abababa"; "Aba")
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information