Subject: Re: [xsl] Is there a way to skip non-numerical data while formatting numbers? From: "Mukul Gandhi" <gandhi.mukul@xxxxxxxxx> Date: Mon, 16 Apr 2007 23:03:49 +0530 |
Input XML is: <x> <price>100</price> <shipping>a</shipping> </x>
XSLT stylesheet is: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/x"> <xsl:value-of select="format-number(number(price), '##,##.00', 'currency_format')"/> ?<xsl:value-of select="format-number(number(shipping), '##,##.00', 'currency_format')"/>? (<xsl:value-of select="format-number(number(price+shipping), '##,##.00', 'currency_format')"/>) </xsl:template>
The output produced is: 1,00.00 ?? ()
The error you are getting is due to the fact, that '##,##,.00' is not the right format pattern. It should be, '##,##.00'
David,
Thank you for the very useful tip.
I tried the following (with some variations):
<xsl:decimal-format name="currency_format" NaN=""/>
<xsl:value-of select="format-number(number(price), '##,##,.00',currency_format)"/>
but the above is throwing a SystemId Unknown; Line #58; Column #102; java.lang.RuntimeException: ElemTemplateElement error: Malformed format string: ##,##,,00 on Xalan XSLT 1.0 parser.
I wasn't getting the above error before (when I didn't use the decimal-format option inside the format-number function.
It could be possible that this is a bug in Xalan according to this post: http://mail-archives.apache.org/mod_mbox/xml-xalan-cvs/200102.mbox/%3C20010215213041.1778.qmail@xxxxxxxxxx%3E
I will check with the Xalan mailing list if it is their bug.
-Rashmi On 4/15/07, David Carlisle <davidc@xxxxxxxxx> wrote: > > you can specify the string used for Not a Number using > xsl:decimal-format, it defaults to 'NaN' but you can make it '' > > David
-- Regards, Mukul Gandhi
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Is there a way to skip no, Rashmi Rubdi | Thread | Re: [xsl] Is there a way to skip no, Rashmi Rubdi |
Re: [xsl] check the type of the $pa, Abel Braaksma | Date | [xsl] XSLT Dead?, Karl Stubsjoen |
Month |