trimming the duplicate values;;very urgent

Hi ,
I ma facing a strange kind of problem. I have an xml file in which there are many duplicate nodes.

This is my xml file.


module11

New Swing Technology
<?employees-employee-projects-project-technologies-technology-title swing?>


XML StyleSheet Language for Transformations
<?employees-employee-projects-project-technologies-technology-title XSLT?>

12-oct-2004
30-oct-2004


module12

New Swing Technology
<?employees-employee-projects-project-technologies-technology-title swing?>


XML StyleSheet Language for Transformations
<?employees-employee-projects-project-technologies-technology-title XSLT?>

31-oct-2004
30-nov-2004


module13

Java Server Pages
<?employees-employee-projects-project-technologies-technology-title JSP?>


Enterprise Java Beans
<?employees-employee-projects-project-technologies-technology-title EJB?>

01-jan-2005
30-jan-2005



In the above xml I have to assignment elements with prj_id=SBBD and the other one is DPSIDSI.
Now I should get the none duplicate values like SBBD and DPSIDSI and no.of distinct nodes as 2

Can anybody send me the solution.

Jithendar

Hi,
You can use the “Muenchian method” which is described >here<.
I have attached a small example that works with your data. Maybe there are other solutions too?
HTH
Example.zip (1.05 KB)