welcome to the forum, @uarhodesian
If you are a newbie at grafana, then I highly recommend using the newest Grafana. Version 8 is far more advanced than version 7, and there have been many improvements to data links
If so, then you could try and use regex-based value mapping + data links (maybe?). Either that or isolate the data inside that string on the DB side before it reaches Grafana…?