DataTable.Value ("Test", dtGlobalSheet) = root.nodeName
Try it
On Fri, Sep 4, 2009 at 7:40 PM, johnthenu <[email protected]> wrote:
>
>
>
> <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
-~----------~----~----~----~------~----~------~--~---
