Reference > Functions reference > Text functions > NumToJText
 
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 number Japanese kanji character number
•3 - traditional kanji 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.