Go to Contents
Previous
Page
 Next
Page
Contents > Functions reference (alphabetical list) > Text functions > NumToJText function
NumToJText function
Format

NumToJText(number;separator;characterType)
Parameters
number - any numeric expression or field containing a number
separator - a number from 0 - 3 representing a separator
characterType - a number from 0 - 3 representing a type
Data type returned
text
Description
Converts Roman numbers in number to Japanese text. 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 character 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 character 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
Contents > Functions reference (alphabetical list) > Text functions > NumToJText function
Previous
Page
 Next
Page