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:
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!