Simon Caldwell wrote:
> I am trying to format a decimal according to local format, ie setting
> the decimal separator to "," instead of "."
> 
> We have defined <xsl:decimal-format decimal-separator=","/> and the
> following
> format-number('1.2', '0,00')
> correctly returns 1,20
> 
> However, the value is being returned from an external source, and is
> already in local format, ie it is passed as '1,2'.  This is not
> recognised as being a number, and the value shown is NaN.
> 
> We've got a solution that seems to work, replacing all occurrences of
> ',' in the input value with '.'
> But this seems wrong somehow.  In order to format a value that already
> has the correct separator, we have to replace it with the wrong
> separator, and then put it back again how it was before.
> 
> Am I missing something, or is this the only way forward?

How number literals in XPath and XSLT look is well defined. And how 
strings are converted to number values is also well defined. 
format-number and xsl:decimal-format are for outputting number values 
not for parsing them. So I am afraid your XML input is broken, it should 
use the '.' as the decimal seperator to store number values. Only for 
presentation such number values should be converted to a string in the 
desired format.



-- 

	Martin Honnen --- MVP XML
	http://JavaScript.FAQTs.com/