Update a node in xml file
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Update a node in xml file
My sample xml file looks like this:
<Ratings>
<Rating>
<RatingCode>AAA</RatingCode>
<RatingDesc>AAA</RatingDesc>
</Rating>
<Rating>
<RatingCode>BBB</RatingCode>
<RatingDesc>BBB</RatingDesc>
</Rating>
<Rating>
<RatingCode>CCC</RatingCode>
<RatingDesc>CCC</RatingDesc>
</Rating>
</Ratings>
My code looks like this:
Set Doc = Sys.OleObject("Msxml2.DOMDocument.6.0")
Doc.async = False
Call Doc.load(filetoload)
Set Node = Doc.documentElement
Set Nodeval = Doc.selectSingleNode("//Quote/Quotesheets/Ratings/Rating/Ratingcode")
Nodeval.Text = texttoupdate
Call Doc.Save(outputfile1)
Set Doc = Nothing
Is there a way to count the no. of children for Ratings and Rating?
Can you please let me know how I can update the second child of Rating. ie, i want to update the value BBB to XXX
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
https://docs.microsoft.com/en-us/dotnet/api/system.xml.xmlnode.selectnodes?view=netframework-4.7.2
https://docs.microsoft.com/en-us/previous-versions/windows/desktop/ms754523(v%3Dvs.85)
/Alex [Community Champion]
____
[Community Champions] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Champions]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Champion] signature is assigned on quarterly basis and is used with permission by SmartBear Software.
https://community.smartbear.com/t5/Community-Champions/About-the-Community-Champions-Program/gpm-p/252662
================================
