NumToJText
 
Purpose 
Converts Arabic numerals to Japanese text.
Format 
NumToJText(number;separator;characterType)
Parameters 
number - any numeric expression or field containing a number
separator - a number from 0 to 3 representing a separator
characterType - a number from 0 to 3 representing a type
Data type returned 
text
Originated in 
FileMaker Pro 6.0 or earlier
Description 
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(Japanese character for ten thousand) and millions(Japanese character for one million) unit
 •
3 - tens(Japanese character for ten), hundreds(Japanese character for one hundred), thousands(Japanese character for one thousand), ten thousands(Japanese character for ten thousand) and millions(Japanese character for one million) unit
Type:
 •
0 - half width (Hankaku) number
 •
1 - full width (Zenkaku) number
 •
2 - Kanji character number Japanese Kanji character number
 •
3 - Traditional-old-style Kanji character number Japanese traditional old-style Kanji number
Examples 
NumToJText(123456789;2;0) returns Arabic numeral "123456789" with half-width hankaku separators between the thousands and ten thousands place, and between the ten millions and hundred millions place
NumToJText(123456789;3;2) returns Japanese text for the Arabic numeral "123456789", using a Kanji number separator between the tens, hundreds, thousands, ten thousands, and millions places
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.