remove commas

Hi

Is there any way to remove a comma from a number using xsl ? e.g

I have the following number:
<MonetaryAmount>842,194.0000000</MonetaryAmount>

but want only:
842194.00

Cheers
Damien

Hi,

maybe this will help:

http://www.w3schools.com/xsl/func_formatnumber.asp

best,
jarra

Hi jarra


I have tried this and it will not work, it looks like the function is unable to interpret the , and the output when I apply my stylesheet is NaN.......so something like the following will not work, I think:

<xsl:value-of select="format-number(123,000.5566, '######.00')"/>

hi

for anyone interested I solved this problem by doing the following:

<xsl:value-of select="format-number(translate(123,555.5566, ',', ''), '.00')"/>


to give the result 123555.55 i.e what I wanted....