Howdy All,

I have just used umb import to impornt (surprise surprise) a bibliography database into umbraco. This however is a problem as the database is incredibley inconsistent. This has lead to my current problem of trying to sort the nodes using <xsl:sort>. Im sorting cronologically by a field named date. However during the import and the state of the database i have some fields that conatain records like "2009may" or "2007 - 2009".

This proves a problem when sorting as these arent in the correct chronological positon that they should be in. Also I am wanting to break it up in sections (blocks of 10 years) which is also poses a problem due to said database. i have tried a substring query/text to take the first 4 characters (the year) and test it against a static value (e.g 1930). I have failed. Is there anyway i can split the field up to only take the year value and test that to make my categories or will i have to re-import that database?

my xsl is as follows

<xsl:template match="/">



   <xsl:for-each select="$currentPage/node[string(data[@alias='umbracoNaviHide']) != '1']">
    <xsl:sort select="./data[@alias = 'bibYear']" data-type="number" order="descending" />
      <xsl:if test="substring(./data,0,'4') &lt; '1930'">
     <xsl:value-of select="@nodeName"/> &nbsp; <xsl:value-of select="./data [@alias = 'bibYear']" />
       </xsl:if>


           <xsl:if test="$currentPage/node [string(data[@alias='bibYear']) &lt; '1930']" >
         <xsl:value-of select="@nodeName"/> &nbsp; <xsl:value-of select="./data [@alias = 'bibYear']" />
           <br/>
   </xsl:if>


   </xsl:for-each>

</xsl:template>

Cheers

Alec