advent-of-code-2022 VS adventofcode

This one hurt, oof. Source here

This would've been much much nicer if count(distinct char) was supported in the window function, oh well. Source here

If I'd allowed myself a tiny bit of preprocessing to turn the input into a 4-column CSV, this is almost a one-liner. (Source here: https://github.com/mrwilson/advent-of-code-2022/blob/main/04/04.sql)

(source here)

Part one went fairly fast, but spent quite some time on getting part two right. I settled on the approach of just iterating over the grid and using a boolean to see if I had to count elements or not. However, I had some issues figuring out when to swap, this post by /u/rogual helped me figure it out. After that I lost quite some time on an error that only occurred with my input, not with the example input. It turned out that my loop (which I take form my p1 solution) didn't include the start node, which caused all sorts of counting issues.

[Language: Elixir] https://github.com/mathsaey/adventofcode/blob/master/lib/2023/4.ex