Using the picture seems to work for me on MarkLogic 7.0-1.   I usually always 
use the picture, I did not even know there were those other parameters.  :)

When would you use a picture vs. setting the grouping size/separator?  Just 
curious if anyone knows the use cases for each.

Chris Cieslinski

From: Ryan Dew <[email protected]<mailto:[email protected]>>
Reply-To: MarkLogic Developer Discussion 
<[email protected]<mailto:[email protected]>>
Date: Friday, January 17, 2014 at 4:48 PM
To: MarkLogic Developer Discussion 
<[email protected]<mailto:[email protected]>>
Subject: Re: [MarkLogic Dev General] xdmp:format-number broken?

That is odd, but it seems you shouldn't have a problem accomplishing what you 
want just using a picture string like so: "#,##0"

let $value := 12312312
return (
  fn:format-number($value,"#,##0")
)
****RESULT****
12,312,312


On Fri, Jan 17, 2014 at 4:38 PM, William Sawyer 
<[email protected]<mailto:[email protected]>> wrote:
Has anyone been able to to get xdmp:format-number grouping-separator and 
group-size parameters to work?

let $value := 12312312
let $picture := "0"
let $language := "en"
let $letter-value := ()
let $ordchar := ()
let $zero-padding := ()
let $grouping-separator := ","
let $grouping-size := 3
return (
  xdmp:format-number($value, $picture, $language, $letter-value, $ordchar, 
$zero-padding, $grouping-separator, $grouping-size)
)
**** RESULT ****
12312312


_______________________________________________
General mailing list
[email protected]<mailto:[email protected]>
http://developer.marklogic.com/mailman/listinfo/general<https://urldefense.proofpoint.com/v1/url?u=http://developer.marklogic.com/mailman/listinfo/general&k=wlPCrglRP6kzT4RbABWMaw%3D%3D%0A&r=7I5W3kfsoen8LHYfpA9jJF64N4fpYpOq2IE0KRgYDd0%3D%0A&m=j4orwVoP6UFLyjGakAjF%2B5QQyrHLI2Hol%2B%2Bx7cDfgpo%3D%0A&s=04f06fbd5cb0df1ef900460f2a8fddfcd4d16c9ff906a007d31375dcedd1981e>



 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.

_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general

Reply via email to