XSL method for instring character from XML data

[SilverStray]

Hi,

Is there a way where I could get the first, or first 2 characters only of a certain data retrieved from XML data?
For example, my data is 'MN123445', and I only want to get the first 2 characters, 'MN', how do I do this in XSL?

thanks in advance!

 

[JontyMC]

http://www.w3schools.com/xpath/xpath_functions.asp

XML:

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <mynode>MN123445</mynode>
</root>

XSL:

<?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="/">
    <result>
      <xsl:value-of select="substring(root/mynode, 1, 2)"/>
    </result>
  </xsl:template>
</xsl:stylesheet>

 

[SilverStray]

Thanks! It worked!