Hello Experts,
I am trying to extract data from XML file which is as follows
<lineage>
<taxon scientificName="Homo" taxId="9605" rank="genus"/>
<taxon scientificName="Homininae" taxId="207598" rank="subfamily" hidden="true"/>
<taxon scientificName="Hominidae" taxId="9604" rank="family"/>
<taxon scientificName="Hominoidea" taxId="314295" rank="superfamily" hidden="true"/>
<taxon scientificName="Catarrhini" taxId="9526" rank="parvorder"/>
<taxon scientificName="Simiiformes" taxId="314293" rank="infraorder" hidden="true"/>
<taxon scientificName="Haplorrhini" taxId="376913" rank="suborder"/>
<taxon scientificName="Primates" taxId="9443" rank="order"/>
<taxon scientificName="Euarchontoglires" taxId="314146" rank="superorder"/>
<taxon scientificName="Eutheria" commonName="placentals" taxId="9347"/>
<taxon scientificName="Theria" taxId="32525" hidden="true"/>
<taxon scientificName="Mammalia" commonName="mammals" taxId="40674" rank="class"/>
<taxon scientificName="Amniota" commonName="amniotes" taxId="32524" hidden="true"/>
<taxon scientificName="Tetrapoda" commonName="tetrapods" taxId="32523" hidden="true"/>
<taxon scientificName="Sarcopterygii" taxId="8287" hidden="true"/>
<taxon scientificName="Euteleostomi" commonName="bony vertebrates" taxId="117571"/>
<taxon scientificName="Teleostomi" taxId="117570" hidden="true"/>
<taxon scientificName="Gnathostomata" commonName="jawed vertebrates" taxId="7776" rank="superclass" hidden="true"/>
<taxon scientificName="Vertebrata" commonName="vertebrates" taxId="7742"/>
<taxon scientificName="Craniata" taxId="89593" rank="subphylum"/>
<taxon scientificName="Chordata" commonName="chordates" taxId="7711" rank="phylum"/>
<taxon scientificName="Deuterostomia" taxId="33511" hidden="true"/>
<taxon scientificName="Coelomata" taxId="33316" hidden="true"/>
<taxon scientificName="Bilateria" taxId="33213" hidden="true"/>
<taxon scientificName="Eumetazoa" taxId="6072" hidden="true"/>
<taxon scientificName="Metazoa" commonName="metazoans" taxId="33208" rank="kingdom"/>
<taxon scientificName="Fungi/Metazoa group" taxId="33154" hidden="true"/>
<taxon scientificName="Eukaryota" commonName="eucaryotes" taxId="2759" rank="superkingdom"/>
<taxon scientificName="cellular organisms" taxId="131567" hidden="true"/>
<taxon scientificName="root" taxId="1" hidden="true"/>
</lineage>
I want the scientificName only when it is not hidden (hidden="true") is not present and in reverse order, starting from bottom like:
Eukaryota;Metazoa;Chordata;Craniata;Vertebrata;Euteleostomi;Mammalia;Eutheria;Euarchontoglires;Primates;Haplorrhini;Catarrhini;Hominidae;Homo..
This is a new thing for me...Can you kindly help me..
Thank you,
Sammed