Advent of Code with OpenRefine Day 3

The way I solved this puzzle has a nice use of value.split(//) to get an array of letters from a string, as well as:

That’s quite a list of functions for something I thought was relatively straightforward!

There’s also a more appropriate use of the OpenRefine Record mode in the second part (although I still revert to the horrible hack used in day 2 to add together all the numbers in a column). Creating the records in the second part includes a neat hack to group together a set number of rows which works easily because of a quirk of the way OpenRefine handles numbers which I completely fail to explain properly in the screen capture!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.