That is indeed a challenging question – so much so, that we previously had a Challenge on just such a case!
Depending on how this data is being retrieved,it may be easier to change the structure of the data to something more easily parsed, but if you truly have no control over it and cannot get these results from WMI instead, we had four successful approaches on the Challenge at Relevance Challenge December 2019 BONUS: Parsing Paragraphs (answer provided)