Hi!

I need format quantity field by adding leading space and align it right.

Like that:

Source:

<OriginalQuantity>1.000</OriginalQuantity>

Target:

<OriginalQuantity> __________1.000</OriginalQuantity>

(_) means space

So I tried different patterns:

<xsl:value-of select="format-number(OriginalQuantity, ###########.###)"/>

<xsl:value-of select="format-number(OriginalQuantity, ###############)"/>

<xsl:value-of select="format-number(OriginalQuantity, )"/>


No one was succesfull :( I've got error message on invalid character or unexpected token.


Would really appreciate any help.

The second argument to format-number should be a string so you will need to wrap the format string into quotes e.g.
format-number(OriginalQuantity, '0.000')

As for right-aligning, that is not possible with format-number, you will need to write your own function (in XSLT 2.0) or template (in XSLT 1.0) that does that although checking http://www.xsltfunctions.com/xsl/c0011.html#c0012 or the XSLT FAQ might turn up solutions for that.

__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog

Try the following, adapted from http://www.xsltfunctions.com/xsl/fun...o-length.html:

<xsl:function name="f:pad-string-to-length" as="xs:string"
xmlns:f="....." >
<xsl:param name="stringToPad" as="xs:string?"/>
<xsl:param name="padChar" as="xs:string"/>
<xsl:param name="length" as="xs:integer"/>

<xsl:sequence select="
string-join (
($stringToPad, for $i in (1 to ($length - string-length($stringToPad)) return $padChar)
,'')
"/>

</xsl:function>

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

On top of what others have said what output format are you using? If it's HTML then you could maybe able able to use CSS to right align and keep your output more 'pure'.

__________________
Joe
http://joe.fawcett.name/

Thanks mhkay, solved problem