How to print numbers in text format in XML Publisher template
The following examples display the function as entered in an RTF template and the returned output:
RTF Template Entry: <?xdofx:to_check_number(12345.67, 2)?>
Returned Output: Twelve thousand three hundred forty-five and 67/100
RTF Template Entry: <?xdofx:to_check_number(12345.67, 'USD')?>
Returned Output: Twelve thousand three hundred forty-five and 67/100
RTF Template Entry: <?xdofx:to_check_number(12345, 'JPY', 'CASE_UPPER')?>
Returned Output: TWELVE THOUSAND THREE HUNDRED FORTY-FIVE
RTF Template Entry: <?xdofx:to_check_number(12345.67, 'EUR', 'CASE_LOWER', 'DECIMAL_STYLE_WORDS')?>
Returned Output: twelve thousand three hundred forty-five and sixty-seven
RTF Template Entry: <?xdofx:to_check_number(12345.67, 2)?>
Returned Output: Twelve thousand three hundred forty-five and 67/100
RTF Template Entry: <?xdofx:to_check_number(12345.67, 'USD')?>
Returned Output: Twelve thousand three hundred forty-five and 67/100
RTF Template Entry: <?xdofx:to_check_number(12345, 'JPY', 'CASE_UPPER')?>
Returned Output: TWELVE THOUSAND THREE HUNDRED FORTY-FIVE
RTF Template Entry: <?xdofx:to_check_number(12345.67, 'EUR', 'CASE_LOWER', 'DECIMAL_STYLE_WORDS')?>
Returned Output: twelve thousand three hundred forty-five and sixty-seven
Metalink Reference Note:
https://community.oracle.com/thread/2242738?tstart=0
Oracle Documentation for using extended functions
https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481158.htm
No comments:
Post a Comment