Hi I have a complex XML data(complete data is pasted below), I would like to sort the records based on attribute.

 
                <itemidlist>
                    <ce:pii>pii1</ce:pii>
                    <ce:doi>tst-doc/9999p1</ce:doi>
                    <itemid idtype="ISSN">00998801</itemid>
                    <itemid idtype="PUI">999</itemid>
                    <itemid idtype="EMBASE">20091099001</itemid>
                </itemidlist>

[download]

if item/itemidlist/itemid attribute idtype is PUI then sort all the records by PUI. Please help me to solve this. This is very very very urgent. Thank you in advance.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<bibdataset xmlns:ce="http://www.elsevier.com/xml/ani/common" xmlns="h
+ttp://www.elsevier.com/xml/ani/ani" xmlns:ait="http://www.elsevier.co
+m/xml/ani/ait" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
+xsi:schemaLocation="http://www.elsevier.com/xml/ani/ani http://www.el
+sevier.com/xml/ani/embase.xsd">
    <item>
        <ait:process-info>
            <ait:date-delivered year="2010" month="02" day="09"/>
            <ait:date-sort year="2008" month="1" day="1"/>
            <ait:status type="core" state="new" stage="S300"/>
        </ait:process-info>
        <bibrecord>
            <item-info>
                <copyright type="Elsevier">Copyright 2010 Elsevier B.V
+., All right reserved.</copyright>
                <itemidlist>
                    <ce:pii>pii1</ce:pii>
                    <ce:doi>tst-doc/9999p1</ce:doi>
                    <itemid idtype="ISSN">00998801</itemid>
                    <itemid idtype="PUI">999</itemid>
                    <itemid idtype="EMBASE">20091099001</itemid>
                </itemidlist>
                <history>
                    <date-created year="2009" month="01" day="30"/>
                </history>
                <dbcollection>EMBASE</dbcollection>
            </item-info>
            <itemfilelinks>
                <itemfilelink href="mytest" MIME-type="application/pdf
+"/>
            </itemfilelinks>
            <head>
                <citation-info>
                    <citation-type code="ar"/>
                    <citation-language xml:lang="eng"/>
                    <author-keywords>
                        <author-keyword>Talipexole</author-keyword>
                        <author-keyword>MAO-B</author-keyword>
                        <author-keyword>MAO-A</author-keyword>
                        <author-keyword>Antidepressants</author-keywor
+d>
                        <author-keyword>5-HT</author-keyword>
                        <author-keyword>Antagonist</author-keyword>
                        <author-keyword>Bromocriptine</author-keyword>
                    </author-keywords>
                </citation-info>
                <citation-title>
                    <titletext xml:lang="fin" original="n">avrandiska 
+brandsre</titletext>
                    <titletext xml:lang="eng" original="y">zz1 Optical
+ 3D measurement of diabetes neuronal network dynamics</titletext>
                </citation-title>
                <author-group>
                    <author type="AU" seq="1">
                        <ce:initials>L.N.P.</ce:initials>
                        <ce:indexed-name>ParraL.N.P.</ce:indexed-name>
                        <ce:degrees>Mrs.</ce:degrees>
                        <ce:surname>Parra</ce:surname>
                        <ce:given-name>Nicky</ce:given-name>
                        <ce:e-address>para@ucla.org</ce:e-address>
                    </author>
                    <author type="AU" seq="1">
                        <ce:initials>R.</ce:initials>
                        <ce:indexed-name>UstinovR.</ce:indexed-name>
                        <ce:surname>Ustinov</ce:surname>
                    </author>
                    <author type="AU" seq="1">
                        <ce:initials>A.</ce:initials>
                        <ce:indexed-name>BargaraA.</ce:indexed-name>
                        <ce:degrees>Mr.</ce:degrees>
                        <ce:surname>Bargara</ce:surname>
                        <ce:given-name>Aravind</ce:given-name>
                    </author>
                    <affiliation>
                        <ce:text>test address</ce:text>
                    </affiliation>
                </author-group>
                <author-group>
                    <author type="AU" seq="2">
                        <ce:initials>T.G.</ce:initials>
                        <ce:indexed-name>SimpsonT.G.</ce:indexed-name>
                        <ce:degrees>Mr.</ce:degrees>
                        <ce:surname>Simpson</ce:surname>
                    </author>
                    <author type="AU" seq="2">
                        <ce:initials>V.S.</ce:initials>
                        <ce:indexed-name>Menard-PickardV.S.</ce:indexe
+d-name>
                        <ce:degrees>Mrs.</ce:degrees>
                        <ce:surname>Menard-Pickard</ce:surname>
                        <ce:given-name>Victoria</ce:given-name>
                    </author>
                    <affiliation>
                        <ce:text>test address2</ce:text>
                    </affiliation>
                </author-group>
                <abstracts>
                    <abstract original="y">
                        <ce:para>UNDEF:This diabetes is a1 a4 Columbia
+ eat Tea man or sour a11 C1 C2 an atrticle on cancer related diseases
+ and their effects</ce:para>
                    </abstract>
                </abstracts>
                <source type="j" country="usa">
                    <volumetitle>Allergy Treatment  from citations</vo
+lumetitle>
                    <issuetitle>Allergy medicines from citations</issu
+etitle>
                    <issn type="electronic">00998801</issn>
                    <part>part779</part>
                    <volisspag>
                        <voliss issue="1"/>
                        <pagerange last="85" first="82"/>
                        <pagecount type="arabic">4</pagecount>
                    </volisspag>
                    <article-number>artnr333</article-number>
                    <publicationyear first="2008"/>
                    <publisher>
                        <publishername>NPG</publishername>
                    </publisher>
                    <publisher>
                        <affiliation>
                            <organization>NPG</organization>
                        </affiliation>
                    </publisher>
                    <additional-srcinfo>
                        <reportinfo>
                            <reportnumber>reportnr222</reportnumber>
                        </reportinfo>
                    </additional-srcinfo>
                </source>
                <enhancement>
                    <descriptorgroup>
                        <descriptors type="MED" controlled="y">
                            <descriptor>
                                <mainterm weight="b">disease</mainterm
+>
                            </descriptor>
                            <descriptor>
                                <mainterm weight="a"/>
                            </descriptor>
                        </descriptors>
                        <descriptors type="DRG" controlled="y">
                            <descriptor>
                                <mainterm weight="b">aspirin</mainterm
+>
                            </descriptor>
                        </descriptors>
                    </descriptorgroup>
                    <manufacturergroup>
                        <manufacturers type="MNF">
                            <manufacturer>Organon</manufacturer>
                        </manufacturers>
                    </manufacturergroup>
                </enhancement>
            </head>
            <tail>
                <bibliography refcount="3">
                    <reference id="1">
                        <ref-info>
                            <ref-title>
                                <ref-titletext>test reference number 1
+</ref-titletext>
                            </ref-title>
                            <ref-sourcetitle>Journal of super testing<
+/ref-sourcetitle>
                            <ref-publicationyear first="2005"/>
                            <ref-volisspag>
                                <voliss volume="volume 7" issue="speci
+al issue for functional testing"/>
                                <pagecount type="roman">3</pagecount>
                            </ref-volisspag>
                            <ref-website>
                                <websitename>SuperTest</websitename>
                            </ref-website>
                        </ref-info>
                    </reference>
                    <reference id="2">
                        <ref-info>
                            <ref-title>
                                <ref-titletext>test reference number 2
+</ref-titletext>
                            </ref-title>
                            <ref-sourcetitle>Journal of super testing<
+/ref-sourcetitle>
                            <ref-publicationyear first="2005"/>
                            <ref-volisspag>
                                <voliss volume="volume 7" issue="speci
+al issue for functional testing"/>
                                <pagecount type="roman">3</pagecount>
                            </ref-volisspag>
                            <ref-website>
                                <websitename>SuperTest</websitename>
                            </ref-website>
                        </ref-info>
                    </reference>
                    <reference id="3">
                        <ref-info>
                            <ref-title>
                                <ref-titletext>test reference number 3
+</ref-titletext>
                            </ref-title>
                            <ref-sourcetitle>Journal of super testing<
+/ref-sourcetitle>
                            <ref-publicationyear first="2005"/>
                            <ref-volisspag>
                                <voliss volume="volume 7" issue="speci
+al issue for functional testing"/>
                                <pagecount type="roman">3</pagecount>
                            </ref-volisspag>
                            <ref-website>
                                <websitename>SuperTest</websitename>
                            </ref-website>
                        </ref-info>
                    </reference>
                </bibliography>
            </tail>
        </bibrecord>
    </item>
    <item>
        <ait:process-info>
            <ait:date-delivered year="2010" month="02" day="09"/>
            <ait:date-sort year="2010" month="1" day="1"/>
            <ait:status type="core" state="new" stage="S300"/>
        </ait:process-info>
        <bibrecord>
            <item-info>
                <copyright type="Elsevier">Copyright 2010 Elsevier B.V
+., All right reserved.</copyright>
                <itemidlist>
                    <itemid idtype="PUI">932</itemid>
                    <itemid idtype="EMBASE">20091099032</itemid>
                </itemidlist>
                <history>
                    <date-created year="2009" month="01" day="30"/>
                </history>
                <dbcollection>EMBASE</dbcollection>
            </item-info>
            <head>
                <citation-info>
                    <citation-type code="ar"/>
                    <citation-language xml:lang="eng"/>
                </citation-info>
                <citation-title>
                    <titletext xml:lang="eng" original="y">zz32</title
+text>
                </citation-title>
                <abstracts>
                    <abstract original="y">
                        <ce:para>UNDEF:this is nothing achieve</ce:par
+a>
                    </abstract>
                </abstracts>
                <source type="j" country="mex">
                    <volisspag>
                        <voliss issue="1"/>
                    </volisspag>
                    <publisher>
                        <publishername>NPG</publishername>
                    </publisher>
                    <publisher>
                        <affiliation>
                            <organization>NPG</organization>
                        </affiliation>
                    </publisher>
                </source>
                <enhancement>
                    <classificationgroup>
                        <classifications type="EMCLASS">
                            <classification>
                                <classification-code>39.22</classifica
+tion-code>
                                <classification-description>Simsalabim
+</classification-description>
                            </classification>
                        </classifications>
                    </classificationgroup>
                </enhancement>
            </head>
        </bibrecord>
    </item>
    <item>
        <ait:process-info>
            <ait:date-delivered year="2010" month="02" day="09"/>
            <ait:date-sort year="2010" month="1" day="1"/>
            <ait:status type="core" state="new" stage="S300"/>
        </ait:process-info>
        <bibrecord>
            <item-info>
                <copyright type="Elsevier">Copyright 2010 Elsevier B.V
+., All right reserved.</copyright>
                <itemidlist>
                    <itemid idtype="PUI">928</itemid>
                    <itemid idtype="EMBASE">20091099028</itemid>
                </itemidlist>
                <history>
                    <date-created year="2009" month="01" day="30"/>
                </history>
                <dbcollection>EMBASE</dbcollection>
            </item-info>
            <head>
                <citation-info>
                    <citation-type code="ar"/>
                    <citation-language xml:lang="eng"/>
                </citation-info>
                <citation-title>
                    <titletext xml:lang="eng" original="y">zz28</title
+text>
                </citation-title>
                <abstracts>
                    <abstract original="y">
                        <ce:para>UNDEF:this is nothing argief</ce:para
+>
                    </abstract>
                </abstracts>
                <source type="j" country="mex">
                    <volisspag>
                        <voliss issue="1"/>
                    </volisspag>
                    <publisher>
                        <publishername>NPG</publishername>
                    </publisher>
                    <publisher>
                        <affiliation>
                            <organization>NPG</organization>
                        </affiliation>
                    </publisher>
                </source>
                <enhancement>
                    <descriptorgroup>
                        <descriptors type="MED" controlled="y">
                            <descriptor>
                                <mainterm>side effect</mainterm>
                            </descriptor>
                        </descriptors>
                        <descriptors type="DRG" controlled="y">
                            <descriptor>
                                <mainterm weight="a">cisaspirin</maint
+erm>
                            </descriptor>
                            <descriptor>
                                <mainterm>paracetamol</mainterm>
                            </descriptor>
                            <descriptor>
                                <mainterm>placebo</mainterm>
                            </descriptor>
                        </descriptors>
                    </descriptorgroup>
                    <classificationgroup>
                        <classifications type="EMCLASS">
                            <classification>
                                <classification-code>39.20</classifica
+tion-code>
                                <classification-description>Energies</
+classification-description>
                            </classification>
                            <classification>
                                <classification-code>39.21</classifica
+tion-code>
                                <classification-description>Allergies<
+/classification-description>
                            </classification>
                        </classifications>
                    </classificationgroup>
                </enhancement>
            </head>
        </bibrecord>
    </item>
    <item>
        <ait:process-info>
            <ait:date-delivered year="2010" month="02" day="09"/>
            <ait:date-sort year="2010" month="1" day="1"/>
            <ait:status type="core" state="new" stage="S300"/>
        </ait:process-info>
        <bibrecord>
            <item-info>
                <copyright type="Elsevier">Copyright 2010 Elsevier B.V
+., All right reserved.</copyright>
                <itemidlist>
                    <itemid idtype="PUI">911</itemid>
                    <itemid idtype="EMBASE">20091099011</itemid>
                </itemidlist>
                <history>
                    <date-created year="2009" month="01" day="30"/>
                </history>
                <dbcollection>EMBASE</dbcollection>
            </item-info>
            <head>
                <citation-info>
                    <citation-type code="pa"/>
                    <citation-language xml:lang="eng"/>
                    <patent>
                        <registrations>
                            <registration>USP 4 025 003</registration>
                        </registrations>
                        <localapplications>
                            <localapplication>0033775</localapplicatio
+n>
                        </localapplications>
                        <prioapplications>
                            <prioapplication>0033776</prioapplication>
                        </prioapplications>
                        <designatedcountries>
                            <country iso-code="167"/>
                            <country iso-code="43"/>
                            <country iso-code="77"/>
                            <country iso-code="87"/>
                        </designatedcountries>
                        <ipc-codes>
                            <ipc-code>C12P-007/40</ipc-code>
                            <ipc-code>C12P-007/41</ipc-code>
                            <ipc-code>C12P-007/42</ipc-code>
                        </ipc-codes>
                    </patent>
                </citation-info>
                <citation-title>
                    <titletext xml:lang="eng" original="y">zz11</title
+text>
                </citation-title>
                <abstracts>
                    <abstract xml:lang="FIN" original="y">
                        <ce:para>UNDEF:his study examines diabetes the
+ effects of neurotensin (NT) on single neurons in explants of the pre
+optic-anterior hypothalamus</ce:para>
                    </abstract>
                </abstracts>
                <source type="j" country="ind">
                    <volisspag>
                        <voliss issue="1"/>
                    </volisspag>
                    <publisher>
                        <publishername>Oxford Press</publishername>
                    </publisher>
                    <publisher>
                        <affiliation>
                            <organization>Oxford Press</organization>
                        </affiliation>
                    </publisher>
                </source>
            </head>
        </bibrecord>
    </item>
    <item>
        <ait:process-info>
            <ait:date-delivered year="2010" month="02" day="09"/>
            <ait:date-sort year="2010" month="1" day="1"/>
            <ait:status type="core" state="new" stage="S300"/>
        </ait:process-info>
        <bibrecord>
            <item-info>
                <copyright type="Elsevier">Copyright 2010 Elsevier B.V
+., All right reserved.</copyright>
                <itemidlist>
                    <itemid idtype="PUI">918</itemid>
                    <itemid idtype="EMBASE">20091099018</itemid>
                </itemidlist>
                <history>
                    <date-created year="2009" month="01" day="30"/>
                </history>
                <dbcollection>EMBASE</dbcollection>
            </item-info>
            <head>
                <citation-info>
                    <citation-type code="ar"/>
                    <citation-language xml:lang="eng"/>
                </citation-info>
                <citation-title>
                    <titletext xml:lang="eng" original="y">zz18</title
+text>
                </citation-title>
                <abstracts>
                    <abstract original="y">
                        <ce:para>UNDEF:politics influence the business
+ environment to a great extent</ce:para>
                    </abstract>
                </abstracts>
                <source type="j" country="mex">
                    <volisspag>
                        <voliss issue="1"/>
                    </volisspag>
                    <publisher>
                        <publishername>NPG</publishername>
                    </publisher>
                    <publisher>
                        <affiliation>
                            <organization>NPG</organization>
                        </affiliation>
                    </publisher>
                </source>
                <enhancement>
                    <descriptorgroup>
                        <descriptors type="MED" controlled="y">
                            <descriptor>
                                <mainterm weight="a">aspirin</mainterm
+>
                                <link>human</link>
                            </descriptor>
                        </descriptors>
                    </descriptorgroup>
                </enhancement>
            </head>
        </bibrecord>
    </item>
    <item>
        <ait:process-info>
            <ait:date-delivered year="2010" month="02" day="09"/>
            <ait:date-sort year="2010" month="1" day="1"/>
            <ait:status type="core" state="new" stage="S300"/>
        </ait:process-info>
        <bibrecord>
            <item-info>
                <copyright type="Elsevier">Copyright 2010 Elsevier B.V
+., All right reserved.</copyright>
                <itemidlist>
                    <ce:pii>pii4</ce:pii>
                    <ce:doi>bla-doc/66p12</ce:doi>
                    <itemid idtype="ISSN">00998803</itemid>
                    <itemid idtype="PUI">908</itemid>
                    <itemid idtype="EMBASE">20091099008</itemid>
                </itemidlist>
                <history>
                    <date-created year="2009" month="01" day="23"/>
                </history>
                <dbcollection>EMBASE</dbcollection>
            </item-info>
            <head>
                <citation-info>
                    <citation-type code="ar"/>
                    <citation-language xml:lang="eng"/>
                </citation-info>
                <citation-title>
                    <titletext xml:lang="eng" original="y">zz8</titlet
+ext>
                </citation-title>
                <source type="j" country="ind">
                    <issn type="electronic">00998803</issn>
                    <volisspag>
                        <voliss issue="1"/>
                    </volisspag>
                    <publisher>
                        <publishername>Oxford Press</publishername>
                    </publisher>
                    <publisher>
                        <affiliation>
                            <organization>Oxford Press</organization>
                        </affiliation>
                    </publisher>
                </source>
            </head>
        </bibrecord>
    </item>
    <item>
        <ait:process-info>
            <ait:date-delivered year="2010" month="02" day="09"/>
            <ait:date-sort year="2010" month="1" day="1"/>
            <ait:status type="core" state="new" stage="S300"/>
        </ait:process-info>
        <bibrecord>
            <item-info>
                <copyright type="Elsevier">Copyright 2010 Elsevier B.V
+., All right reserved.</copyright>
                <itemidlist>
                    <ce:pii>pii8</ce:pii>
                    <itemid idtype="ISSN">00998804</itemid>
                    <itemid idtype="PUI">909</itemid>
                    <itemid idtype="EMBASE">20091099009</itemid>
                </itemidlist>
                <history>
                    <date-created year="2009" month="01" day="22"/>
                </history>
                <dbcollection>EMBASE</dbcollection>
            </item-info>
            <head>
                <citation-info>
                    <citation-type code="re"/>
                    <citation-language xml:lang="eng"/>
                </citation-info>
                <citation-title>
                    <titletext xml:lang="eng" original="y">zz9 for dia
+betes research in North America</titletext>
                </citation-title>
                <source type="j" country="ind">
                    <issn type="electronic">00998804</issn>
                    <volisspag>
                        <voliss issue="1"/>
                    </volisspag>
                    <publisher>
                        <publishername>Oxford Press</publishername>
                    </publisher>
                    <publisher>
                        <affiliation>
                            <organization>Oxford Press</organization>
                        </affiliation>
                    </publisher>
                </source>
            </head>
        </bibrecord>
    </item>
</bibdataset>

[download]

In reply to Sort xml based on attribute by bharathinc

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.