Reference > Functions reference > Text 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 .