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](../FMP_Help/images/numtojtext01.png)
) and millions(
![Japanese character for one million](../FMP_Help/images/numtojtext02.png)
) unit
•3 - tens(
![Japanese character for ten](../FMP_Help/images/numtojtext03.png)
), hundreds(
![Japanese character for one hundred](../FMP_Help/images/numtojtext04.png)
), thousands(
![Japanese character for one thousand](../FMP_Help/images/numtojtext05.png)
), ten thousands(
![Japanese character for ten thousand](../FMP_Help/images/numtojtext06.png)
) and millions(
![Japanese character for one million](../FMP_Help/images/numtojtext07.png)
) unit
Type:
•0 - half width (Hankaku) number
•1 - full width (Zenkaku) number
•2 - Kanji character number
![Japanese Kanji character number](../FMP_Help/images/numtojtext08.png)
•3 - Traditional-old-style Kanji character number
![Japanese traditional old-style Kanji number](../FMP_Help/images/numtojtext09.png)
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](../FMP_Help/images/numtojtext10.png)
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](../FMP_Help/images/numtojtext11.png)
Related topics