RE: [xsl] format number with changeable currency symbol

Subject: RE: [xsl] format number with changeable currency symbol
From: "James Steven" <JSteven@xxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 18 Jun 2004 14:45:29 +0100
If I have a negative number surely concat() will not be able to put the
minus sign to the left of the currency symbol which is how format number
displays it.

I have tried using <xsl:if> as shown below but this isn't displaying
anything.  Should this method work and if yes is there anything wrong with
the code?

<xsl:variable name="Symbol" select="Anything/CurrencySymbol"/>
<xsl:if test="contains($Symbol, '$')">
<xsl:value-of select="format-number($sumorg, '$###,###,##0.00')"/>
</xsl:if>



-----Original Message-----
From: Michael Kay [mailto:mhk@xxxxxxxxx]
Sent: 18 June 2004 12:28
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE: [xsl] format number with changeable currency symbol


> I have been able to put in a currency symbol with xslt 1.0
> using format
> number.  But that currency symbol is fixed.  Is there a way
> to interchange
> the currency symbol whilst keeping the minus sign to the left
> of it.  What
> do you mean by doing it "by hand"?

I mean add the currency sign to the number using concat().

Michael Kay


>
> -----Original Message-----
> From: Michael Kay [mailto:mhk@xxxxxxxxx]
> Sent: 18 June 2004 10:30
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: RE: [xsl] format number with changeable currency symbol
>
>
> XSLT 1.0 explicitly doesn't allow the currency symbol, though some
> implementations may let you get away with it (XSLT 1.0 specified
> format-number() in terms of the JDK 1.1 specifications, but
> implementations
> using a newer release of Java may "accidentally" expose facilities
> introduced in later JDK versions.)
>
> I would avoid trying to do this with format-number(), and do
> it "by hand".
>
> Michael Kay
>
> > -----Original Message-----
> > From: James Steven [mailto:JSteven@xxxxxxxxxxxxxxxxxxxxx]
> > Sent: 18 June 2004 09:33
> > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> > Subject: [xsl] format number with changeable currency symbol
> >
> > Hello
> > I would like to format a number so that it can be shown with
> > any type of
> > currency symbol in front of it.  Currently I am using eg.
> > <xsl:value-of
> > select="format-number(12345, '?###,###,##0.00')"/> but this
> > only formats the
> > number with a ?.
> >
> > Also I have tried putting a currency symbol element in the
> > xml and including
> > that in the xsl to be inserted before the number.  The
> > trouble with this
> > method is that if the figure is a negative number the minus
> > sign is inserted
> > after the currency symbol which is no good.  Is there a way that the
> > format-number function can be used with a currency symbol
> > element from the
> > xml so that the currency symbol can be changed in the xml?
> > Or is there any
> > other way to solve this?
> >
> > Thanks for your help.
> > James
> >
> >
> >
> >
> >
> >
> --+------------------------------------------------------------------
> > XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> > To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> > or e-mail: <mailto:xsl-list-unsubscribe@xxxxxxxxxxxxxxxxxxxxxx>
> > --+--
> >
> >
>
>
> --+------------------------------------------------------------------
> XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: <mailto:xsl-list-unsubscribe@xxxxxxxxxxxxxxxxxxxxxx>
> --+--
>
>
>
> This message has been scanned for unacceptable content by 'VITANIUM'
> the industry leading email virus and content management service from
> Vitanium Systems. Contact details are available at www.vitanium.com.
>
>
>
>
>
> --+------------------------------------------------------------------
> XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: <mailto:xsl-list-unsubscribe@xxxxxxxxxxxxxxxxxxxxxx>
> --+--
>
>


--+------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe@xxxxxxxxxxxxxxxxxxxxxx>
--+--



This message has been scanned for unacceptable content by 'VITANIUM'
the industry leading email virus and content management service from
Vitanium Systems. Contact details are available at www.vitanium.com.





Current Thread