How to remove rich text or markup text code

I have a field pulling into my datasource that appears to be a rich text type field; viewing from Transform Data view, this is what it looks like: 

However, the only data I want to keep in this field is the data highlighted in YELLOW.  I have already confirmed there is not a commonality between all my rows of data, so I can't do this based on a specific delimiter or set of characters. I have also confirmed that using Html.Table does not work, nor does Transform > Clean or Transform > Trim.  Any ideas on how to get this field to report out with just the details?

Thanks in advance!