Link to home
Start Free TrialLog in
Avatar of pucko73
pucko73

asked on

Help finding nodes based on atributes in xml

Hello, can someone help me
with a query that goes through a xml
and find all nodes with the atribute name
and gives the value of name atribute and value of the "NodeName"
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Please post a sample Xml document and the expected result.
Avatar of pucko73
pucko73

ASKER

<root>
  <node1  name="test">
      <subnode1 name "subtest1">
      </subnode1>
  </node1>
   
  <node2  name="test2">
      <subnode2 name "subtest2">
      </ubsub1 name='subsubtest"> </subsub1>
      </subnode2>


  </node2>

</root>

a good result for this would be a table walue
with

Col Node:                                     name
/root                                            Null
/root/node1                                 test
/root/node1/subnode1                subtest1
/root/node2                                 test2
/root/node2/subnode2                subtest2
/root/node2/subnode2/subsub1  subsubtest
ASKER CERTIFIED SOLUTION
Avatar of keyu
keyu
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial