<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version = "1.0"
    xmlns:xsl = "http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

<xsl:template match="Order"><xsl:text/>
<xsl:variable name="ref" select="normalize-space(./OrderReferences)"/>

<xsl:variable name="ref1" select="normalize-space(./Sender/SenderReferences/GLN)"/>
<xsl:text/>
<xsl:variable name="ref2" select="('0000000000')"/>


<xsl:for-each select="./OrderLine">
<xsl:value-of select="$ref"/>
<xsl:value-of select="$ref1"/>
<xsl:value-of select="$ref2"/>
<xsl:value-of select="format-number(normalize-space(LineNumber),'000000')"/>
<xsl:value-of select="concat('00000000000',normalize-space(Product/TradeUnitCode))"/><xsl:text/>
<xsl:value-of select="format-number(normalize-space(substring-before(Quantity,'.')), '000000000000')"/><xsl:text/>
<xsl:value-of select="('000000000000')"/>#013;<xsl:text/>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

my output file is:

N10072242009PT500333041415056300000000000026400000 00000007316224000000001200000000000000
N10072242009PT500333041415056300000000000026500000 00000007345132000000000300000000000000

What i would like is to format this <xsl:variable name="ref" select="normalize-space(./OrderReferences)"/> to have 20 characteres but i can´t use the format-number instruction because it have alphanumeric characteres and then i get NaN.
Can someone help me please.

To pad an arbitrary string $s with leading "0" characters to a length of 20 characters, try

substring(concat('00000000000000000000', $s), string-length($s)+1)

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

mhkay but where i put normalize-space(./OrderReferences) in you instruction:
substring(concat('00000000000000000000', $s), string-length($s)+1)

Please put my instruction in yours, please.

Thank you.

I gave you an expression that you can apply to any input string, which I called $s. If you want to apply it to the result of normalize-space(./OrderReferences) then you can either replace $s by that expression, or you can assign the result of that expression to a variable and use the variable.

This seems rather basic.

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

<!ELEMENT train (engine?, wagon*)>
<!ELEMENT engine(#PCDATA)>
<!ELEMENT wagon(#PCDATA)>


murugesan

Well this wins the award of the month for the most cryptic post :)

--

Joe (Microsoft MVP - XML)

Thank you mhkay it work just fine.
You are the best.

joefawcett are you joking about my post????!!!

No, I should have quoted the one I was talking about, the one from murgesh :)

--

Joe (Microsoft MVP - XML)

No problem, i was only joking with you.