What an interesting challenge!
Took a little while to wrap my head around this one. Lots of bug finding later.
This is tough challenge...
GitHub
https://github.com/AkimasaKajitani/AdventOfCode/tree/main/2021
Only Part 1 (for now...) I hope I have time to solve Part2 (Is it as hard as I think?)
Ooof, this one was rough. Took a while to wrap my brain around how to approach, but once I figured it out, it was just a matter of going through a lot of Parse + Join + Filter iterations... possibly the most RegEx parse tools I've ever used in a workflow 🙂 This one is ugly... but it did the trick.
Here's the final messy beast. Not my finest work, but glad that after a (restless) night's sleep, my brain figured out how to finish this one.
Cheers!
NJ
I have created the worst formula nightmare ... but ... I might have won tool golf ... (only took hours to figure out every detail). Decision was on purpose to not build a macro and/or build something smart. I quickly came to the point where I knew "this could be a one formula thing" and I decided I'll never leave that path.
The idea is to reorder each entry, then use the number with unique letter count to match match others, eg when 1 (2 letters) concatenate with 2, 3, 5 (5 letters), after remove duplicate letters, only results left represents 3. After a bit iteration on the macro we can deduce all the numbers for each line.
Though the workflow is definitely not something efficient, will look out for better ideas from others.