xslt help needed - urgent

[techza]

Hello,

I have a xml file below from which I want to extract the data using xslt. I trying to create the xslt but no results , I have some hard coated values in the xslt which I want in the output xml.
I also need the other values from the below xslt. But I don't know hoew to seperate the special characters.
I want to display the date from the below xslt , the last 2 lines in my xml has the date value, I don't know how to select it.

Kindly help

XML File :

<DATA>
<TEST_NAME="null" CTO_ZZZ_ID="null" SHIP_DATE="" INVOICE_NUMBER="AT45748"

TEST_XML_DATA="&lt;xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;&gt;&#xD;&#xA;&#x9;&lt;parent
testType= &quot;T&quot; display=&quot;N &quot; gt;&#xD;&#xA;&#x9;&#x9;&lt;
preview&gt;&lt;/preview&gt;&#xD;&#xA;&#x9;&lt;
testificate&gt;&#xD;&#xA;&#x9;&lt;
invoicelabel&gt;Invoice Number: &lt;/invoicelabel&gt;&#xD;&#xA;&#x9;&lt;
invoicenumber&gt;AT45748&lt;/invoicenumber&gt;&#xD;&#xA;&#x9;&lt;
stocklabel&gt;Stock Number: &lt;/stocklabel&gt;&#xD;&#xA;&#x9;&lt;
iddesc&gt;60-0200-1496-9 3TA98-AF COND 4.25 IN&lt;/iddesc&gt;&#xD;&#xA;&#x9;&lt;
testcontent expDisp=&quot;false&quot;
testtype=&quot;T&quot; font=&quot;&quot; locale=&quot;en&quot; orderInfoAvlbleFlag=&quot;true&quot; previewFont=&quot;Arial&quot; testCommDisp=&quot;false&quot; cpsiaInvoice=&quot;false&quot; optCommentFlag=&quot;false&quot; &gt;&#xD;&#xA;&#x9;&#x9;&lt;logo&gt;&lt;/logo&gt;&#xD;&#xA;&#x9;&#x9;&lt;testtitle locale=&quot;en&quot;&gt;&#xD;&#xA;&#x9;&#x9;&lt;title&gt;testificate of testing&lt;/title&gt;&#xD;&#xA;&#x9;&#x9;&lt;/testtitle&gt;&#xD;&#xA;&#x9;&#x9;&lt;exception locale=&quot;en&quot;&gt;&#xD;&#xA;&#x9;&#x9;&lt;text&gt;&lt;/text&gt;&#xD;&#xA;&#x9;&#x9;&lt;/exception&gt;&#xD;&#xA;&#x9;&#x9;&lt;locationAddress locale=&quot;en&quot;&gt;&#xD;&#xA;&#x9;&#x9;&lt;firstline1&gt;YYYY&lt;/firstline1&gt;&#xD;&#xA;&#x9;&#x9;&lt;secondline1&gt;Bldg 19-01-usa Rd&lt;/secondline1&gt;&#xD;&#xA;&#x9;&#x9;&lt;thirdline1&gt;usa 55016&lt;/thirdline1&gt;&#xD;&#xA;&#x9;&#x9;&lt;/locationAddress&gt;&#xD;&#xA;&#x9;&#x9;&lt;customerAddress locale=&quot;en&quot;&gt;&#xD;&#xA;&#x9;&#x9;&lt;firstline2&gt;EMA US ACRES&lt;/firstline2&gt;&#xD;&#xA;&#x9;&#x9;&lt;secondline2&gt;2222 AVE&lt;/secondline2&gt;&#xD;&#xA;&#x9;&#x9;&lt;thirdline2&gt;HILLSBORO OR 971245506 &lt;/thirdline2&gt;&#xD;&#xA;&#x9;&#x9;&lt;/customerAddress&gt;&#xD;&#xA;&#x9;&#x9;&lt;

testdate locale=&quot;en&quot;&gt;&#xD;&#xA;&#x9;&#x9;&lt;label&gt;Date testificate is prepared:&lt;/label&gt;&#xD;&#xA;&#x9;&#x9;&lt;date&gt;Jun-10-2009&lt;/date&gt;&#xD;&#xA;&#x9;&#x9;&lt;/testdate &gt;&#xD;&#xA;&#x9;&#x9;&lt;

----

XSLT File:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" encoding="utf-8" omit-xml-declaration="no" indent="yes" />
<xsl:template match="/">
<xsl:element name="File" namespace="x-schema:../Schema/testificateSchema2001Jul.xml">
<xsl:element name="FileInfo" namespace="x-schema:../Schema/testificateSchema2001Jul.xml">
<xsl:element name="responsiblePartyEmail" namespace="x-schema:../Schema/ChemGasQualitytestificateSchema2001Jul.xml">[e-mail]</xsl:element>
</xsl:element>
<xsl:element name="BusinessSites" namespace="x-schema:../Schema/testificateSchema2001Jul.xml">
<xsl:element name="Description" namespace="x-schema:../Schema/testificateSchema2001Jul.xml">
<xsl:element name="manufacturerNumber" namespace="x-schema:../Schema/testificateSchema2001Jul.xml">678748</xsl:element>
<xsl:element name="manufacturerName" namespace="x-schema:../Schema/testificateSchema2001Jul.xml">TEST</xsl:element>
<xsl:element name="manufacturingPlantCode" namespace="x-schema:../Schema/testificateSchema2001Jul.xml">341403</xsl:element>
<!-- <xsl:element name="incomingFaxNumber"></xsl:element> obsolete /-->
<!--DUNSPlusFour/-->
<xsl:element name="manufacturer" namespace="x-schema:../Schema/testificateSchema2001Jul.xml">TEST1</xsl:element>

<xsl:variable name="testingDate" select="//testdate/date" />
<xsl:variable name="testMonth" select="substring(//testdate/date,1,3)" />
<xsl:variable name="testMonthDigits">
<xsl:choose>
<xsl:when test="$testMonth='Jan'">01</xsl:when>
<xsl:when test="$testMonth='Feb'">02</xsl:when>
<xsl:when test="$testMonth='Mar'">03</xsl:when>
<xsl:when test="$testMonth='Apr'">04</xsl:when>
<xsl:when test="$testMonth='May'">05</xsl:when>
<xsl:when test="$testMonth='Jun'">06</xsl:when>
<xsl:when test="$testMonth='Jul'">07</xsl:when>
<xsl:when test="$testMonth='Aug'">08</xsl:when>
<xsl:when test="$testMonth='Sep'">09</xsl:when>
<xsl:when test="$testMonth='Oct'">10</xsl:when>
<xsl:when test="$testMonth='Nov'">11</xsl:when>
<xsl:when test="$testMonth='Dec'">12</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$testMonth" />
</xsl:otherwise>
</xsl:choose>
</xsl:variable>
</xsl:element>
</xsl:element>
</xsl:element>
</xsl:element>
</xsl:template>
</xsl:stylesheet>