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
I'm not a big fan of RegEx to start with and I probably attacked this in the wrong way. But in the end, I got the right answer, so there is that.
I started by adding a record count, as I thought initially I was going to have to split the data by date time as I parsed out the info and I wanted a way to ensure I didn't duplicate, then decided that if I waterfalled the selections (by letting those selections that I'd already solved for fall out of the process) it would allow me to narrow down the data regex to a better degree. At the end, I unioned them back together for the final result. I added a validation piece that allowed me to check my results against those results provided as well.