Functions Reference

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.