How to find adjacent alphanumeric number

sen1953 · August 29th, 2013, 07:04 AM

Hi All,

This is my xml

Code:

<namelist>
 <order>
     <name>JAMES</name>
      <accNo>10D</accNo>
 </order>
 <order>
      <name>ARAFAT</name>
      <accNo>07A</accNo>
 </order>
 <order>
       <name>anotherbranchaccount</name>
       <accNo>20J</accNo>
 </order>
 <order>
       <name>JAMES</name>
       <accNo>20K</accNo>
 </order>
 <order>
      <name>JOHN</name>
      <accNo>9A</accNo>
 </order>
 <order>
      <name>anotherbranchaccount</name>
      <accNo>10E</accNo>
 </order>
</namelist>

Expected output

JAMES 10D ANOTHERACCOUNT 10E
ARAFAT 07A
JAMES 20K ANOTHERACCOUNT 20J

My problem

I got to match with 'anotherbranchaccount'element which accNo is adjacent to JAMES 'accNo' .There is no sequence like main account number then extra account node.
Give me solution. I dont have any idea about that.because we have many alphanumeric comibanations like [A-Z][1 TO 100]
How to solve this issue? Please help me out.

samjudson · August 29th, 2013, 09:36 AM

You could sort by something like this to sort by number, then character:

Code:

<xsl:for-each select="order">
   <xsl:sort select="translate(accNo, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '')" data-type="number"/>
   <xsl:sort select="translate(accNo, '0123456789', '')" data-type="text"/>
 <!-- do something in here -->
</xsl:for-each>

The translate function would replace all of the characters in the first string with the corresponding character in the second string, which if this doesn't exists effectively deletes the character.