Subject:Converting XML String Data to Numeric Author:Brandon H. Date:08 Dec 2005 12:26 PM
I have a problem with numeric XML data coming into my XSL with comma separators. I need to somehow convert this comma separated number from the string that XSL thinks it is, into a numeric so I can use the result in a multiplication operation.
I have tried using the format-number() function no it, and it returns 'NaN'.
My only other thought is to somehow remove the commas from the string, and then convert the result into a numeric, and finally proceed with the math.
Subject:Converting XML String Data to Numeric Author:Minollo I. Date:08 Dec 2005 12:45 PM
Assuming the commas in the number can be safely removed without affecting the meaning of the number (as in the case where they are "thousands" markers), then you can easily do that using the translate() function:
<xsl:value-of select="translate('123,456', ',', '')"/>
...will output: 123456