Reference > Functions reference > Japanese functions > NumToJText
 

NumToJText

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 kanji number

Example 1 

NumToJText(123456789;2;0) returns Arabic numeral 123456789 with half-width hankaku (1-byte) separators between the thousands and ten thousands places, and between the ten millions and hundred millions places.

Example 2 

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