0

I have a insanely large file that has a lot of customer data in XML format. The start of a customer <CUSTOMER> and end </CUSTOMER> are how I'll determine the starting and ending points of the customer data I need to extract. The <DOC_NUM> is the number I'll be searching for. I'll input a regular text file with 12-byte document numbers into the file (Doc Number List.txt), search the massive XML file (example.xml) for those document numbers, find the data before and after the DOC_NUM tags, but within the CUSTOMER tags and extract it to a formated file. The formated file needs to have these tags, <?xml version="1.0" encoding="ISO-8859-1"?>
<DOCUMENTS> ....... </DOCUMENTS>

Any help is greatly appreciated.

Thanks!!

Attachments
10000001780513
10000001780516
10000001780517
10000001780521
2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by Oxiegen
0

Import the source XML into a DataTable.
Then you can use the Select() method to filter out what you're looking for.
The result can then be exported into a new destination XML.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.