Discussion thread for day 6 of the Advent of Code - https://adventofcode.com/2022/day/6
@AkimasaKajitani , have to admit that I googled that one to get it correct. Knew it was possible, just didn't know how to write the statement
@DavidP nice use of the regex lookahead there. I had to put it into regexr to work out what it was doing.
My python solution is much cleaner than my Alteryx solution 😂 #SnakingMyWayThroughChallenges
@atcodedog05 brilliant solution! I would never have thought to build out a regex expression that way to identify duplicates.
I've officially made it farther in the challenge than I ever have in the last few years I've been attempting this 😁
Solution:
Macro:
Luckily I made the macro easy to scale :) the only difference between Part 1 and Part 2 was the number of records I was choosing with my Select Records tool and the filter requirements.
Think my second answer is actually simpler than the first, but wasn't going to bother to rewrite the first one.