Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > PatternCount function |
|
|
| PatternCount function |
| 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. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > PatternCount function |
|
|
Next Page |
|