I have some very large XML files which are provided from an external source. I need to search through the files to isolate certain lines based on search criteria, eg ABNStatusFromDate="20180101", <State>ACT</State> and <EntityTypeText>Australian Private Company</EntityTypeText>.
I have tried opening the files in Excel and the Windows XML Notepad reader. They crash due to the size. I can open them in the FirstObject reader very quickly and I can search one by one by each date and then double check to see if the state and entity type matches the two above criteria. But this will obviously take forever.
Is there a way I can do this quickly and extract by date and matching criteria into a smaller XML file or Excel?
I won't attach the file because of the size. Below are a couple of lines from the XML file.
Many thanks for any assistance which can be given.