[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
if so, would this do what you want? Treating it as a string rather than number?
insert yer favorite currency symbol as a variable if necessary...?
James Steven wrote:
Re: [xsl] format number with changeable currency symbol
Subject: Re: [xsl] format number with changeable currency symbol From: Brian Chrisman <brian.chrisman@xxxxxx> Date: Fri, 18 Jun 2004 12:59:16 -0700 |
Are you trying to format the string: $-5,000.00 into -$5,000.00?
if so, would this do what you want? Treating it as a string rather than number?
<xsl:variable name="firsttwo" select="substring(Num, 1, 2)"/> <xsl:choose> <xsl:when test="contains($firsttwo, '$-')"> <xsl:value-of select="concat('-$', substring-after(Num, $firsttwo))"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="Num"/> </xsl:otherwise> </xsl:choose>
insert yer favorite currency symbol as a variable if necessary...?
James Steven wrote:
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.
--+------------------------------------------------------------------
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>
--+--
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] format number with change, James Steven | Thread | RE: [xsl] format number with change, James Steven |
Re: [xsl] How to copy parts of an v, david_n_bertoni | Date | xsl:include with parameter?, yguaba |
Month |