I am working with kml file converting it to our database format and extracting some information along with the shapes. One of the attributes of kml has the info that I need. It looks like that (which seems to be html format):
<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor='#E3E3F3'><th>AlertID</th><td>18112330</td></tr><tr bgcolor=''><th>DateTime</th><td>20181222124132.000</td></tr><tr bgcolor='#E3E3F3'><th>AlertRegionID</th><td>2111030</td></tr><tr bgcolor=''><th>RegionTypeID</th><td>1</td></tr></table></center>
From that one attribute I'd like to extract the important info minus all the tags, brackets and formatting as separate attributes:
AlertID 18112330
DateTime 20181222124132.000
AlertRegionID 2111030
RegionTypeID 1