Vbscript code to edit xml file

How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. VBscript to edit xml file Ask Question. Asked 7 years, 10 months ago. I tried to write my own script, but there is a Error line 1 char Expected end of statement :. But still I have a problem: rowID is not 3 all the time, it is changing every time I update my xml.

Dev Center. Explore Why Office? Android ASP. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Log In. I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit! Thanks for the suggestion EBGreen , but I tried that already. I wouldn't be asking here if that had worked to my satisfaction. You can get xpath to all Company:Qty and verify if it starts with a negative sign your "dash".

If yes, eliminate it. Something like this. Thanks tsuji. Once again, you've solved my problem. I also noticed something interesting.

If you look further down in the XML structure, you'll notice that some keys or tags have subkeys: Genres for example uses Genre subkeys. Subkeys are used when multiple values are possible. They can be viewed best in XML Notepad's treeview. OK, listing properties for each item in a collection no longer has any secrets for you.