MarkLogic 12 EA 2 Product Documentationxdmp:format-number
xdmp:format-number( $value as xs:numeric*, [$picture as xs:string?], [$language as xs:string?], [$letter-value as xs:string?], [$ordchar as xs:string?], [$zero-padding as xs:string?], [$grouping-separator as xs:string?], [$grouping-size as xs:integer?] ) as xs:string
Summary
Returns a formatted number value based on the picture argument.
The difference between this function and the W3C standards
fn:format-number
function is that this function imitates
the XSLT xsl:number instruction, which has richer
formatting options than the fn:format-number
fn:format-number
function.
This function can be used for spelled-out and ordinal numbering
in many languages. This function is
available in XSLT as well as in all dialects of XQuery and Server-Side
JavaScript.
| Parameters | |
|---|---|
| value |
The given numeric $value that needs to be formatted.
|
| picture |
The desired string representation of the given numeric $value.
The picture string is a sequence of characters, in which the
characters represent variables such as, decimal-separator-sign,
grouping-sign, zero-digit-sign, digit-sign, pattern-separator,
percent sign and per-mille-sign. For details on the picture string, see
http://www.w3.org/TR/xslt20/#date-picture-string.
Unlike fn:format-number(), here the picture string allows
spelled-out (uppercase, lowercase and Capitalcase) formatting.
|
| language |
The desired language for string representation of the numeric
$value.
An empty sequence must be passed in even if a user doesn't want to
specify this argument.
|
| letter-value | Same as letter-value attribute in xsl:number. This argument is ignored during formatting as of now. It may be used in future. An empty sequence must be passed in even if a user doesn't want to specify this argument. |
| ordchar | If $ordchar is "yes" then ordinal numbering is attempted. If this is any other string, including an empty string, then cardinal numbering is generated. An empty sequence must be passed in even if a user doesn't want to specify this argument. |
| zero-padding | Value of $zero-padding is used to pad integer part of a number on the left and fractional part on the right, if needed. An empty sequence must be passed in even if a user doesn't want to specify this argument. |
| grouping-separator | Value of $grouping-separator is a character, used to groups of digits, especially useful in making long sequence of digits more readable. For example, 10,000,000- here "," is used as a separator after each group of three digits. An empty sequence must be passed in even if a user doesn't want to specify this argument. |
| grouping-size | Represents size of the group, i.e. the number of digits before after which grouping separator is inserted. An empty sequence must be passed in even if a user doesn't want to specify this argument. |
Usage Notes
Most, but not all formatting combinations work. The following table shows formatting options by language, and lists what is supported and what is not.
| Language | Numeric Cardinals | Numeric Ordinals | Spelled Out Cardinals | Spelled Out Ordinals |
|---|---|---|---|---|
| en | Yes | Yes | Yes | Yes |
| fr | Yes | Yes | Yes | No |
| it | Yes | Yes | Yes | No |
| de | Yes | No | Yes | Yes |
| ru | Yes | No | Yes | No |
| es | Yes | Yes | Yes | No |
| ar | Yes | Yes | Yes | No |
| zh | Yes | Yes | Yes | Yes |
| ko | Yes | Yes | Yes | Yes |
| fa | Yes | No | Yes | No |
| nl | Yes | Yes | Yes | Yes |
| ja | Yes | Yes | Yes | Yes |
| pt | Yes | Yes | Yes | No |
Example
xdmp:format-number(29,"01","en","",(),'0',",",3), xdmp:format-number(09,"W","en","",(),'"',",",3), xdmp:format-number((5),"w","es",(),(),"0",",",3) => 29 NINE cinco
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.