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

[OllieClarke]

Here's my first attempt:

Spoiler

There must be a single formula solution using RegEx. Will look for it now

[JamesCharnley]

Spoiler

Might be a bit of an overcomplication but I've built so many iteratives recently this might actually be faster for me than messing around in formulas.

[leozhang2work]

Spoiler

WorkflowIterative macro

Never tried so many iterations, a first for me.

[DawnDuong]

My first attempt, which uses iterative macro, is based on intuition. Part 1 and Part 2 are similar.

Spoiler

Iterative macro:
Main workflow:

Will look through others' solutions especially the crazy Regex / Formula tool ones :)

[DawnDuong]

Very neat Formula tool @atcodedog05 

[DawnDuong]

Combining the formula and the Generate row into a single Generate Row is a super idea @AkimasaKajitani , can you share how you did that?

[Carlo_S]

Tried at first to do a massive if-else but finally came round to doing some regex 😅

Spoiler

Spoiler

[afv2688]

Solution with one tool :)

Spoiler

[AkimasaKajitani]

Here is the Generate row setting of my 2nd solution. I think that the expression is too long.

Spoiler

[DawnDuong]

Thanks @AkimasaKajitani  for sharing the formula.