In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
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. 😀