ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more here
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. 😀