Retrieve distinct values from xml using xpath

nelly78 · March 24th, 2010, 02:30 PM

Hi All,

how can I retieve distinct values from xml document using xpath.

from the below Xml i want to retrieve all the user's name for example 'YU','john' etc. Once

how can I do that using xpath expression.

Code:

 
<?xml version="1.0" encoding="utf-8"?>
<ACF>
  <form name="Customer Information of category" default="">
    <user name="Yu" id="55758" >
      <department>Development</department>
    </user>
    <user name="john" id="56308">
      <department>Development</department>
    </user>
    <user name="Sid" id="56309" >
      <department>Development</department>
    </user>
    <user name="Harry" id="56198" >
      <department>Development</department>
    </user>
  </form>
  <form name="Department Information Testing" default="">
   <user name="Yu" id="55758" >
      <department>Development</department>
    </user>
    <user name="john" id="56308">
      <department>Development</department>
    </user>
    <user name="Sid" id="56309" >
      <department>Development</department>
    </user>
    <user name="Harry" id="56198" >
      <department>Development</department>
    </user>
  </form>
  <form name="Department Information Testing" default="">
   <user name="Yu" id="55758" >
      <department>Development</department>
    </user>
    <user name="john" id="56308">
      <department>Development</department>
    </user>
    <user name="Sid" id="56309" >
      <department>Development</department>
    </user>
    <user name="Harry" id="56198" >
      <department>Development</department>
    </user>
  </form>  
</ACF>

Thank you very much.
-Nelly

mhkay · March 24th, 2010, 07:07 PM

Code:

distinct-values(//user/@name)