Here's my solution... I was hoping to use Regex a lot more but this got the job done quickly and was more in my wheelhouse. Very interested to look through other solutions. Thanks!
Edit: I see after perusing some of the other submitted solutions, that you can use the formula tool to add the clue column. I'll need to give that a try. Mine was not quite a complete solution. 😀