Discussion thread for day 3 of the Advent of Code - https://adventofcode.com/2022/day/3
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!
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
Doesn't need to be pretty to work
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.
I'm giving up on trying to be elegant and clean.
I'm also giving up on that in Alteryx.
Easy so far. It's in the post, though.
Calm before the storm..
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!
Part 1 Formula: