XML/XSL Sort

[Drewsuredaddy]

I have XML code that looks like the following:

<root name="PlanRepository">
  <directory name="connoraj">
    <directory name="singlerun">
      <file>insidebox.txt</file>
      <file>outsidebox.txt</file>
      <directory name="SAFE_Input">
        <file>leapseconds.txt</file>
        <file>single_run.dat</file>
        <directory name="LeoInputs">
          <file>control_earth.txt</file>
          <file>leo_sc_prop2.txt</file>
        </directory>
      </directory>
      <directory name="SAFE_Output">
        <file>single_run.aer.dat</file>
        <file>single_run.control_files</file>
        <file>single_run.dv.dat</file>
        <file>single_run.host_ephem.e</file>
        <file>single_run.host_inertial.dat</file>
        <file>single_run.residuals.dat</file>
        <file>single_run.tar_ephem.e</file>
      </directory>
    </directory>
  </directory>
</root>

And my goal is, that in each <directory> to sort its respective <file>s by extension, then write it back in XML format. I can get this all to work, except for getting the <directory> tags to close correctly.

This is the XSL I am using:

<xsl:template match="/">
    &lt;root name="PlanRepository"&gt;
    <br/>
  <xsl:for-each select="//directory">
    &lt;directory name="<xsl:value-of select="@name"/>"&gt;
    <br/>
    <xsl:choose>
      <xsl:when test="@name = 'SAFE_Output'">
        <xsl:for-each select="file">
          <xsl:sort select="substring-after(substring-after(.,'.'),'.')" />
          &lt;file&gt;<xsl:value-of select="."/>&lt;/file&gt; 
          <br/>
        </xsl:for-each>
      </xsl:when>
      <xsl:otherwise>
        <xsl:for-each select="file">
          <xsl:sort select="substring-after(.,'.')" />
          &lt;file&gt;<xsl:value-of select="."/>&lt;/file&gt;
          <br/>
        </xsl:for-each>
      </xsl:otherwise>
    </xsl:choose>
    &lt;/directory&gt;
    <br/>
  </xsl:for-each>
    &lt;/root&gt;
</xsl:template>

This XSL yields the following XML output:

<root name="PlanRepository">
  <directory name="connoraj">
  </directory>
  <directory name="singlerun">
    <file>insidebox.txt</file>
    <file>outsidebox.txt</file>
  </directory>
  <directory name="SAFE_Input">
    <file>single_run.dat</file>
    <file>leapseconds.txt</file>
  </directory>
  <directory name="LeoInputs">
    <file>control_earth.txt</file>
    <file>leo_sc_prop2.txt</file>
  </directory>
  <directory name="SAFE_Output">
    <file>single_run.control_files</file>
    <file>single_run.aer.dat</file>
    <file>single_run.dv.dat</file>
    <file>single_run.host_inertial.dat</file>
    <file>single_run.residuals.dat</file>
    <file>single_run.host_ephem.e</file>
    <file>single_run.tar_ephem.e</file>
  </directory>
</root>

So as you can see, the files are correctly sorted by extension, but the XML formatting is no longer the same.

Any ideas? Please help!

Thanks,
Andrew

[Drewsuredaddy]

This is the XSL code I used that correctly sorted the files:

  <xsl:template match="root">
    &lt;root name="PlanRepository"&gt;
    <br/>
    <xsl:apply-templates />
    &lt;/root&gt;
  </xsl:template>

  <xsl:template match="directory">
    <xsl:param name="directoryName">
      <xsl:value-of select="@name" />
    </xsl:param>
    &lt;directory name="<xsl:value-of select="@name"/>"&gt;
    <br/>
    <xsl:choose>
      <xsl:when test="$directoryName = 'SAFE_Output'">
        <xsl:for-each select="file">
          <xsl:sort select="substring-after(substring-after(.,'.'),'.')" />
          &lt;file&gt;<xsl:value-of select="."/>&lt;/file&gt;
          <br/>
        </xsl:for-each>
      </xsl:when>
      <xsl:otherwise>
        <xsl:for-each select="file">
          <xsl:sort select="substring-after(.,'.')" />
          &lt;file&gt;<xsl:value-of select="."/>&lt;/file&gt;
          <br/>
        </xsl:for-each>
      </xsl:otherwise>
    </xsl:choose>
    <xsl:apply-templates/>
    &lt;/directory&gt;
    <br/>
  </xsl:template>