I have exported some windows event logs which has created a text file. This is a mixture of text and XML.
I am looking for a way to go through the text file and extract the XML whilst ignoring the plain text. I would then like to take each line of XML data and place it into a a row of its own. Essentially creating a new row for each event within the log.
I have attached the event log output and also a spreadsheet that shows how I would like it to look. I've done this manually, but I want to export around 100 logs and can't go through it manually for that many.