How to remove rich text or markup text code

[DataIsMyMN]

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! 

[Ritaf1983]

Hi @DataIsMyMN 
Maybe just replace the common unnecessary strings with nothing it seems "system" phrases that repeat.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly