barthelonafan barthelonafan - 1 year ago 48
Python Question

How to parse out xml from noisy file using python

I have a file which contains a bunch of logging information including xml. I'd like to parse out the xml portion into a string object so I can then run some xpaths on it to ensure to existence of certain information on the 'data' element.

File to parse:

Requesting event notifications...
Receiving command objects...
<?xml version="1.0" encoding="UTF-8"?><Root xmlns="" xmlns:xsi=""><data id="123" interface="2017.1" implementation="2016.122-SNAPSHOT" Version="2016.1.2700-SNAPSHOT"></data></Root>
All information has been collected
Command execution successful...


import re

with open('./output.out', 'r') as outFile:
data ='\n','')

regex = re.escape("<.*?>.*?<\/Root>");
p = re.compile(regex)
m = p.match(data)

if m:
print('No match')


No match

What am I doing wrong? How can I accomplish my goal? Any help would be much appreciated.

Answer Source

Thou shalt never use regular expressions for parsing XML/HTML. There is BeautifulSoup for this daunting task.

import bs4
soup = bs4.BeautifulSoup(open("output.out").read(), "lxml")
roots = soup.findAll('root')
#[<root xmlns="" 
# xmlns:xsi="">
# <data id="123" implementation="2016.122-SNAPSHOT" interface="2017.1" 
# version="2016.1.2700-SNAPSHOT"></data></root>]

roots[0] is an XML document. You can do anything you want with it.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download