Discussion thread for day 1 of the Advent of Code - https://adventofcode.com/2024/day/1
In the holiday spirit! 🎄 Day 1 Solutions below:
Whoops. Forgot it was Dec 1!! Quick solve once I remembered that's it's the most wonderful time of the year!! 🎉
Like last year, I'll be keeping an eye out for fun new things we've released in Designer in the past few releases that help speed up time to AoC solve... would love to hear if others find new options, functions, and features helpful too!! So far, I'm once again loving the ability to set up an AoC-specific Custom Workflow Template to get a quick start each day, and loving the GetPart function for parsing starting data in a Formula! ❤️
Happy AOC solving!!
Phew. Day 1 behind me!
A lovely challenge to kick things off with! Nice and quick addition to go from part 1 > part 2.
Note: If you're looking for an easy way to generate all of your starting files - check out this app I built recently! https://github.com/DataNath/AoC_startFile_generator
Nice challenge to start with
A nice start to advent of code 2024 - I'm sure there is much madness yet to come Solved with "help" from my 5yo son this morning, who really wants me to help the elves save Christmas!My solution attached:
I've defined List 1 and List 2 using the Formula tool:List 1 = ToNumber(Regex_replace([data], "(\d+) +(\d+)", "$1"))List 2 = ToNumber(Regex_replace([data], "(\d+) +(\d+)", "$2"))Here the \d characters represent any numeric character, and I'm asking for 1 or more of that pattern. I use two capture groups, by encasing the numeric character patterns in round brackets. The " +" pattern represents 1 or more spaces, and since this is not in a capture group then this part of the string is ignored. The Regex_Replace function allows you to reference the capture groups by number using the "$" notation.
Not the prettiest, but I'm on the board!
AOC Day 1 workflow.
Day 1 is not so harsh to me.
in "text to column" set config as "Drop extra column with warning" and "skip emtpy column" will trim the extra space. while default is not.
DAY 1 LETSS GOOOOO🚀
Solved.
I tried it.
first challenge
Nice Day1!
Day 1 done, first time using ABS in a formula, great way to learn about tools and best practice with themed scenarios, now on to Day 2! 😀
Fun game! I love it
Left my laptop in the office over the weekend, so trying to catch up now
Probably used way too many select tools
Day 1! A bit late to the party..
Just catching up after being away yesterday.
Enjoyed this one.
Good to be back at it!
Day 1! Great start!
Excited for day 2
My Attempt
It's ugly, but I got my star!
