Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
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. 😀