RE: [xsl] + Signed Number Format

Subject: RE: [xsl] + Signed Number Format
From: "Michael Kay" <mhk@xxxxxxxxx>
Date: Tue, 4 Mar 2003 00:12:17 -0000
> Hi.
> I want to use the function  format-number to to put a number 
> in a  money  format.  This works when the number is either 
> not signed or negatively signed. The XML we got from our 
> client has a "+" sign like this example:
> <xsl:value-of select="format-number(+00003345351.89,'$#,###.00')"/>

XPath 1.0 doesn't allow a leading plus sign in a number. You can get rid
of it using translate($num, '+', '').
> This won't work.  The same proble is when I use the function 
> sum() on a column that has positive values represented with  
> "+" signed numbers.
> Any clues
> Thanks
> Here is the definition of a positive number accoriding to the 
> w3c XML Schema Part 2: Datatypes specs. So according to these 
> standards an xml can have the "+" infront of a number. 

XPath 1.0 predates XML Schema: its authors did a good job, but
predicting the contents of XML Schema would have been nothing short of

XPath 2.0 fixes this.

Michael Kay
Software AG
home: Michael.H.Kay@xxxxxxxxxxxx
work: Michael.Kay@xxxxxxxxxxxxxx 

 XSL-List info and archive:

Current Thread