<abc:Title>MISS</abc:Title>
<abc:FirstName>test</abc:FirstName>
<abc:Surname>case</abc:Surname>
<abc:Gender>FEMALE</abc:Gender>
<abc:DOB>1965-12-01</abc:DOB>
<abc:MaritalStatus>SING</abc:MaritalStatus>
<abc:LocalBorn>true</abc:LocalBorn>
<abc:LocalLivingStartDate>2000-01-01</abc:LocalLivingStartDate>
<abc:Status>EMP</tpf:Status>
Hi, I want to Extract text between <Title> tag and export it to
Datatable with Column Name Title_Name…..and I want to extract text
between <FirstName> tag and export the text to Datable with column
name First_Name and so on….
I have the below script which extract all the text between the child
elements, but I just want the text between individual elements and
export it to datatable in the respective column. Any Help will be very
much appreciated.
set xmlDoc=CreateObject("Microsoft.XMLDOM")
xmlDoc.async= False
xmlDoc.load("C:\Documents and Settings\get\Desktop\test.xml")
Set root = xmlDoc.documentElement
For each x in root.childNodes
DataTable.Value ("Test", dtGlobalSheet) = root.childNodes.item
(i).text
Next
Many Thanks,
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
-~----------~----~----~----~------~----~------~--~---
