Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFun challenge to practice regex, particularly the "()" as the marking group. I also tried the Find/Replace tool for first time, which helped normalize the street suffixes.
I've impressed myself with this one as someone who doesn't really know RegEx.
I highly recommend the RegEx class within the Parsing Data Interactive Lessons (https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...) if you need a hand getting started with this stuff.