How to Extract Data from Multilayer XML Parent-Child Nodes to Form a List

Problem description & analysis

Below is data in XML file xml.xml:

undefined

To get categories and detailed data from the multilayer XML file and generate a two-dimensional table as follows:

undefined

Solution:

We write the following script p1.dfx in esProc:

A

1

=file("xml.xml").read()

2

=xml(A1,"xml/li/form")

3

=A2.news(p.select.option;h3:name,~:time)

4

=file("result.txt").export@t(A3)

 

Code description:

A1  Read data of the XML file as a string.

A2  Use xml function to get data of form layer and return it as a table sequence.

A3  Extend the multiple p.select.option values in table sequence A2 and concatenate them to generate a new table sequence.

A4  Export A3’s result to result.txt.

result.txt is the expected result after the script is executed.

Q & A Collection

https://stackoverflow.com/questions/63684666/vba-scraping-data-in-ticketing