Solved

How to parse an XML file with VB Scritp?

Posted on 2015-02-03
4
92 Views
Last Modified: 2015-02-05
I can generate an XML file, as attached.  I have given up on trying to do anything with the data stream as received, and instead am saving it to a .TXT file, which I need to open and then pull out the stuff I want with VB Script.  In the attached file, I need to capture the value of the APNMB field, then the date associated with each FWDAY field.  So output should look like this in the target file:

Application:  12345678
Date:  2011-05-06
Date:  2011-10-06
.
.
the rest of the date (FWDAY) fields until the end of the list.  I have found a few parsers on line, but they seem to be accessing a web site not a file; I didn't understand them anyway!
3D.txt
0
Comment
Question by:Mike Caldwell
  • 3
4 Comments
 
LVL 22

Accepted Solution

by:
plusone3055 earned 500 total points
ID: 40588502
0
 
LVL 1

Author Comment

by:Mike Caldwell
ID: 40588850
Great help 3055.  This works fine:

Set xmlDoc = _
  CreateObject("Microsoft.XMLDOM")

xmlDoc.Async = "False"
xmlDoc.Load("3D.txt")

Set colNodes=xmlDoc.selectNodes _
  ("//APNMB")

For Each objNode in colNodes
msgbox "Application: " & objnode.text
Next

Open in new window


 I can pull out APNMB or FWTYP, but having trouble still in two ways:  listing out the dates under one APNMB, then the FWTYPs under the next APNMB.
0
 
LVL 1

Author Comment

by:Mike Caldwell
ID: 40589337
Correction: there should be a list of FWTYPs under each individual APNMB.
0
 
LVL 1

Author Closing Comment

by:Mike Caldwell
ID: 40592711
Didn't get me all the way; I need to know how to deal with child nodes and their child nodes, but learned a lot and a good start.  I'm probably going to give up using VB Script for this.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I met Paul Devereux (@pdevereux) today when I responded to his tweet asking “Anybody know how to automate adding files from disk to a folder in #outlook  ?”.  I replied back and told Paul that using automation, in this case scripting, to add files t…
Introduction During my participation as a VBScript contributor at Experts Exchange, one of the most common questions I come across is this: "I have a script that runs against only one computer. How can I make it run against a list of computers in …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question