Extracting XML Data With EsProc: A Step-by-Step Guide
Extracting data from XML file: Read xml.xml as string, use xml function to get form layer data & export to 2D table in result.txt using esProc script p1.dfx.
Problem description & analysis Below is data in XML file xml.xml: To get categories and detailed data from the multilayer XML file and generate a two-dimensional table as follows: Solution: We write the following script p1.dfx in esProc: 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 e...