<!–

body{margin:0;padding:0}
<!–[if lte IE 9]>/cdn-cgi/scripts/jquery.min.js<![endif]–>
/cdn-cgi/scripts/zepto.min.js<!–
/cdn-cgi/scripts/cf.common.js

• https://www.w3.org/TR/xpath-functions-30/#func-format-number

Can you imagine, that the 3rd argument needs extra double quotes around? And it’s not easy to find an example showing this, but here I found one:

• https://www.amazon.de/dp/9671317502 – “Web Coding Bible”

declare decimal-format local:de decimal-separator = "," grouping-separator = ".";
declare decimal-format local:en decimal-separator = "." grouping-separator = ",";
let $numbers := (1234.567, 789, 1234567.765)
for $i in $numbers
return (
 format-number($i,"#.###,##","local:de"),
 format-number($i,"#,###.##","local:en")
)

I found this function, but it pads on the right:

• http://www.xqueryfunctions.com/xq/functx_pad-string-to-length.html : functx:pad-string-to-length

I derived pad-string-to-length-on-the-left from it:

• https://github.com/JochenHayek/misc/blob/master/xqueryfunctions/pad-string-to-length-on-the-left.xqy
• https://github.com/JochenHayek/misc/blob/master/xqueryfunctions

I use it around format-integer and format-number, e.g.

let $net_amount_formatted := local:pad-string-to-length-on-the-left( format-number( data($invoice/@net_amount) , '#,###.#####' ) , ' ' , 12 )

• https://www.w3.org/TR/xpath-functions-30
• https://www.w3.org/TR/xpath-functions-30/#formatting-integers
• https://www.w3.org/TR/xpath-functions-30/#formatting-the-number
• http://www.xqueryfunctions.com/xq/functx_pad-integer-to-length.html
• http://www.xqueryfunctions.com/xq/functx_pad-string-to-length.html
• https://github.com/JochenHayek/misc/blob/master/xqueryfunctions
• https://github.com/JochenHayek/misc/blob/master/xqueryfunctions/pad-string-to-length-on-the-left.xqy

I need to pad a decimal number to a given length with leading white space. Looks like there is nothing in the “built-in library”. Looks like there is no functx:pad-integer-to-length as well, but functx:pad-string-to-length looks intriguing – but it only pads on the right. I created a variant, that pads on the left: pad-string-to-length-on-the-left.xqy – pls follow the link shown above!