I want custom order of title, but I am not able to get it, I tried this but it did not work

<xsl:template match="/">
<table class="stripeMe" width="700" cellpadding="5" cellspacing="1">
<thead>
<tr>
<td>Employee Name</td>
<td>Position</td>
<td>CALL US Extension</td>
<td>Direct Line</td>
</tr>

</thead>

<xsl:for-each select="Users/User_Detail">
<xsl:sort select="string-length(substring-before('|District Director|Assitant District Director|ADD|', concat('|', title, '|')))" data-type="number"/>
<xsl:sort select="last_name" order="ascending" />

Based on my none-existent knowledge of what your input XML looks like this will work.

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?

<Users>
<User_Detail>
<last_name>Gauza</last_name>
<first_name>Thomas</first_name>
<office_id>149</office_id>
<new_extension>11235</new_extension>
<current_phone_number>123-456-7890</current_phone_number>
<title>District Director</title>
<Region>5</Region>
</User_Detail>
<User_Detail>
<last_name>Pratt</last_name>
<first_name>Richard</first_name>
<office_id>149</office_id>
<new_extension>852963</new_extension>
<current_phone_number>123-456-0789</current_phone_number>
<title>Assistant District Director</title>
<Region>5</Region>
<User_Detail>
<last_name>Green</last_name>
<first_name>Latonya</first_name>
<office_id>5</office_id>
<new_extension>400029</new_extension>
<current_phone_number>312-596-7200</current_phone_number>
<title>Compliance Specialist</title>
<Region>5</Region>
</User_Detail>
</User_Detail>

</Users>

Assuming Users is the root element of your XSLT then this works fine for me.

You are aware that Latonya Green's User_Detail is actually embedded inside the User_Detail for Richard Pratt, so is never output, right, and you've spelt Assistant wrong in the sort statement?

Also, "|District Director|" returns an empty string - so does a none-match. Try putting an "X" at the start of the string to move the correct match up one.

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?