Advent of Code 2023 Day 1 (BaseA Style)

[AlteryxCommunityTeam]

Discussion thread for day 1 of the Advent of Code - https://adventofcode.com/2023/day/1

[DavidP]

What can possibly go wrong with hard coding? If it works now it will always work...

Spoiler

[caltang]

Question 2 was brutal on my mind

Spoiler

The mapping came in clutch. Goodness...

[starkey]

Spoiler

Happy to be back at it for my third year participating in AOC using alteryx! I used reverse string here to avoid having to come up with complex regex or formulas to solve for instances of overlapping strings or single digits. Not going for tool golf here, just a straightforward solution I was able to build out quickly. Anyone else use reverse string to help with this one?

[DataNath]

My solution to day 1. Took me bloody ages to come up with something for part 2!

Spoiler

[CoG]

My Solution

Part 1:

Spoiler

Part 2:

Spoiler

[cjaneczko]

Had to hard code the overlaps. Not sure how else to do it.

Spoiler

[aiahwieder]

Down with Data Cleanse! Even in a challenge this quick, I can't stand the extra time DC takes, so I always unpack it into just the formula I need . . . added in a little bonus automation to make sure nothing fell through the cracks in the second part. 😁 @joshbennett -- great minds!

[mmontgomery]

Classic AoC to give you a tricky part 2

Spoiler

[afv2688]

Finally done :) not the most elegant but it works!

Spoiler

[starkey]

@phottovy our solutions were almost completely identical! I would understand if someone accused me of plagiarism