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

[bflick]

Build to scale and you'll never fail

Spoiler

Learned my lessons from last year, when in doubt make everything into rows.

[clmc9601]

I used a long formula for the first part knowing it wouldn't work for more than four letters. Naturally, the second part involved more letters 😂 

Spoiler

[atcodedog05]

My take on this using 4 tools and string functions

Spoiler

Happy Analyzing :)
Cheers and have a nice day!

[cgoodman3]

The first day I put my alarm on snooze and I over sleep by a bit so miss out on the opportunity to take on @bflick and @clmc9601  for the fastest solve.

Spoiler

Same approach as @bflick. It would be great if there was a quicker way of building out the list of 4 and 14 strings. In the essense of tool golf putting the recordID tool earlier in the workflow means you only need it once 😉.

[clmc9601]

@cgoodman3 maybe you already did this, but Excel can help assemble the long expressions! Slightly less manual than typing them by hand.

[NicoleJ]

Long way around with a Multi-Row Formula for the solve... then a quick Tool Golf refactor for 7 tools (both parts). Enjoyed the quicker run after yesterday's almost-mind-bender!

Spoiler

Looks like I channeled something similar to @clmc9601 for the Multi-Row version, and then the same Tool Golf score as @bflick ... but different tools/approach, which is cool!

[cgoodman3]

Slight modification to improve the tool golf score and to make it dynamic.

Spoiler

1) Created a user constant "StringLength" which the user can specify to modify the data, which is used in the formula and filter tools
2) Used generate rows to explode the input into many rows
3) Used substring to walk along the input the desired number of letters

[AkimasaKajitani]

My solution.

Part 2 have a large IF statement.

Spoiler

[trung2403]

I have to create a very lengthy Multi-row formula. Will try to do it in a better way.

Spoiler