Functions Reference

Chapter 12
|
Text functions 173
Description
Converts Roman numbers in number to Japanese text. If the value for separator and
characterType are blank or other than 0 to 3, then 0 is used.
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.