Month: July 2016

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,…

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…