[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: adding 2 formatted numbers?
this works... <xsl:template match="/"> <xsl:variable name="numbers"> <xsl:for-each select="//node1/text() | //node2/text()"> <n><xsl:value-of select="translate(.,',.','')"/></n> </xsl:for-each> </xsl:variable> <xsl:value-of select="sum(msxsl:node-set($numbers)//n)"/> </xsl:template> I'm sure others will post something more effecient, but like I said ... this works. Keep in mind that the format of the currency node content must be the same, the segments be of the same type. -Jeff -----Original Message----- From: L Rutker [mailto:lrutker@xxxxxxxxxxx] Sent: Thursday, March 14, 2002 2:55 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: adding 2 formatted numbers? Hi, I have the following nodes in my xml: <node1>123,456,789.01</node1> <node2>222,222,222.54</node2> In my xsl I have to add the value of the 2 of them. Since my numbers are formatted I cant do it. How can I "unformat" my numbers and add them together? Note: depending on the users currency formatting preferences I might get the number in the following format: <node1>123.456.789,01</node1> <node2>222.222.222,54</node2> I also have now way of knowing how many commas there are per node (the length varies) Thanks Lou _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|