Basic XSLT 1

[SiJP]

I'm a complete beginner at xslt, so it comes as no suprise that I'm struggling to understand how to achieve a task.


Take the following XML:


<DataHeader>
<DataDetails>
<F1>12345</F1>
<F2>More Data</F2>
</DataDetails>
</DataHeader>


I need to write an xsl doc that converts it to this structure:


<?xml version="1.0" encoding="UTF-8"?>
<new>
<cols>
<col name="F1">12345</col>
<col name="F2">More Data</col>
</cols>
</new>

Really appreciate some help in doing this!

------------------------
Hit any User to continue

 

[jel]

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="[URL unfurl="true"]http://www.w3.org/1999/XSL/Transform">[/URL]
<xsl:output method = "xml" />
 
 <xsl:template match="/">
  <!-- always create elements new/cols -->
  <xsl:element name="new">
   <xsl:element name="cols">
    <!-- for each node in DataHeader/DataDetails ... -->
    <xsl:for-each select = "DataHeader/DataDetails/*">
     <!-- create an element with the name of current node -->
     <xsl:element name="{name()}">
      <!-- and put the value of current node in -->
      <xsl:value-of select="."/>
     </xsl:element>
    </xsl:for-each>
   </xsl:element>
  </xsl:element>
 </xsl:template>
</xsl:stylesheet>

good luck

 

[SiJP]

Thanks Jel - I had to tweak a few things, but got the general idea of layout etc from your post - definately set me on a winning track.

For those interested, the XSLT 2nd Edition Programmers Reference (Michael Kay, (C) 2001 Wrox Press) is an excellant resource for developers working with xslt.

------------------------
Hit any User to continue

 

[JontyMC]

You don't need the element tags:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="[URL unfurl="true"]http://www.w3.org/1999/XSL/Transform">[/URL]
  <xsl:template match="/">
    <new>
      <cols>
        <xsl:for-each select="DataHeader/DataDetails/*">
          <col name="{name(.)}">
            <xsl:value-of select="."/>
          </col>
        </xsl:for-each>
      </cols>
    </new>
  </xsl:template>
</xsl:stylesheet>

Jon

"There are 10 types of people in the world... those who understand binary and those who don't.