<?xml version='1.0' encoding='utf-8' ?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                xmlns:msxsl="urn:schemas-microsoft-com:xslt"
                xmlns:user="http://mycompany.com/mynamespace"
                version="1.0"><xsl:output method="html"/>

<xsl:include href="Style1.xsl"/>


<xsl:template match="/">


<!-- Call a template that contains html formatting tags -->
<xsl:call-template name="Style1" />


<h1>Employee Listing </h1>


<table border="1">
<tr>
<th>Select</th>
<th>Select</th>
<th>Select</th>
<th>string-length</th>
<th>substring-before 'n'</th>
<th>substring-after 'n'</th>
<th>concat</th>
<th>contains 'i'</th>
</tr>

<xsl:for-each select ="/employees/employee" >

<tr>
<td><xsl:value-of select = "@EmployeeID"/></td>
<td><xsl:value-of select = "@FirstName"/></td>
<td><xsl:value-of select = "@LastName"/></td>
<td><xsl:value-of select = "string-length(@FirstName)"/></td>
<td><xsl:value-of select = "substring-before(@FirstName, 'n')"/></td>
<td><xsl:value-of select = "substring-after(@FirstName, 'n')"/></td>
<td><xsl:value-of select = "concat(@FirstName, ' ', @LastName)"/></td>
<td><xsl:value-of select = "contains(@FirstName, 'i')"/></td>

</tr>

</xsl:for-each> 
</table>
</xsl:template>

</xsl:stylesheet>

