Functions Reference

Separator:
0 - no separator
1 - every 3 digits (thousands)
2 - ten thousands( ) and millions( ) unit
3 - tens( ), hundreds( ), thousands( ), ten thousands( ) and millions( ) unit
Type:
0 - half width (Hankaku) number
1 - full width (Zenkaku) number
2 - Kanji character number
3 - Traditional-old-style Kanji character number
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.