Advent of Code 2022 Day 6 (BaseA Style)

[AlteryxCommunityTeam]

Discussion thread for day 6 of the Advent of Code - https://adventofcode.com/2022/day/6

[grossal]

Forgot to post mine for yesterday, but here we go! No Tool Golf today. 

スポイラ

 Macro: 

[estherb47]

@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

[balders-ie]

Ugly long formula created in notepad++ for part 2 

スポイラ

 

[balders-ie]

@DavidP nice use of the regex lookahead there. I had to put it into regexr to work out what it was doing. 

[Kenda]

スポイラ

[clmc9601]

My python solution is much cleaner than my Alteryx solution 😂 #SnakingMyWayThroughChallenges

スポイラ

 

[starkey]

@atcodedog05 brilliant solution! I would never have thought to build out a regex expression that way to identify duplicates.

[DaisukeTsuchiya]

スポイラ

[Shelbey]

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.

[Watermark]

スポイラ

 

Think my second answer is actually simpler than the first, but wasn't going to bother to rewrite the first one.