Hi,
I have an xml file that has the same tag name for different categories of data. Below is an example. I would like to create an xpath to extract each data category. For example Age is the 4th tag. So I would need the xpath script to navigate to the 4th <item name> tag so I can extract the value of '21' that is located in the 4th <value> tag.
Any help appreciated.
Thanks
<metadata>
<item name="Incident Number" type="xs:string" length="102"/>
<item name="Chief Complaint" type="xs:string" length="202"/>
<item name="PCR Date/Time" type="xs:dateTime"/>
<item name="Age" type="xs:int" precision="1"/>
<item name="Gender" type="xs:string" length="512"/>
<item name="Race" type="xs:string" length="512"/>
<item name="Onset Time" type="xs:dateTime"/>
<item name="Unit Notified" type="xs:dateTime"/>
<item name="Arrive Scene" type="xs:dateTime"/>
<item name="Event Description" type="xs:string" length="512"/>
<item name="Start Time" type="xs:dateTime"/>
<item name="Arrive Destination" type="xs:dateTime"/>
<item name="Drug Name" type="xs:string" length="202"/>
</metadata>
<data>
<row>
<value>10136254</value>
<value>Chest Pain (Non-Cardiac)</value>
<value>2010-09-18T00:54:12</value>
<value>21</value>
<value>Female</value>
<value>Black or African American</value>
<value>2010-09-11T00:00:00</value>
<value>2010-09-18T00:54:12</value>
<value>2010-09-18T01:00:30</value>
<value>12-Lead 1</value>
<value>2010-09-18T01:08:57</value>
<value>2010-09-18T01:40:56</value>
<value xs:nil="true" />
</row>