Category: Text
Syntax: NumToJText ( number; separator; characterType ) |
Parameters:
numberAny numeric expression or field containing a number.
separatorA number from 03 representing a separator.
characterTypeA number from 03 representing a type.
Data type returned: Text (Japanese)
Description:
Converts Roman numbers in the number parameter to Japanese text. If the value for separator and characterType are blank or other than 0 to 3, then 0 is used.
Separator:
0No separator
1Every 3 digits (thousands)
2Ten thousands and millions unit
3Tens , hundreds , thousands , ten thousands , and millions unit
Type:
0Half width (Hankaku) number
1Full width (Zenkaku) number
2Kanji character number
3Traditional-old-style Kanji character number
Examples:
Function | Results |
---|---|
NumToJText(123456789;2;0) | Returns . |
NumToJText(123456789;3;2) | Returns . |
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
Calculation Signatures
Calculation Functions
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Scripting Primer
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information