Advent of Code 2022 Day 3 (BaseA Style)

[AlteryxCommunityTeam]

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

[MeganDibble]

I'm enjoying looking at everyone's solution to see the smarter way to do things ;)

 

Spoiler

[peter_gb]

ChartoInt you little beauty!

Finally happy with this being quite neat. 
Cba with tool golf but I do want my solutions to look nice and clear. This'll do!

Spoiler

 

[estherb47]

Loving CharToInt and ReplaceChar formulae today!! 2 tools for the first part, and 3 for the second! But a lot of formulas in each formula tool

Spoiler

[bflick]

Doesn't need to be pretty to work

Spoiler

[KevinHarrison]

I feel like maybe I went too complex when seeing others but I went with iterative macros to go through all the letters. It would take the first letter and check and then remove that letter and do that every letter. So I had to make a macro for each one. I see a lot of people using regex with the tokenize and need to look into that. But It seem like you have to hard code the column numbers and I kind have issue with that when dataset might change and have more next time the elves do this.

Generating the alphabet was fun and learned the chartoint and charfromInt which was fun. 

Spoiler

[clmc9601]

Solved a second time using Python #SnakingMyWayThroughChallenges

Spoiler

[mceleavey]

I'm giving up on trying to be elegant and clean. 

I'm also giving up on that in Alteryx.

Spoiler

Easy so far. It's in the post, though.

Calm before the storm..

[Jean-Balteryx]

Day 3 done ! ✅

A lot of tools for a not so hard challenge !

Spoiler

[starkey]

Pretty happy with the simplicity of my part 1 solution, but part 2 made me take a totally different approach. I had fun with this one!

Spoiler

Part 1 Formula:

[OllieClarke]

couldn't think of a nice way to generate the priority :

Spoiler