Advent of Code 2023 Day 1 (BaseA Style)

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!

Trebuchet.yxmd

mmontgomery

Classic AoC to give you a tricky part 2

Spoiler

2023_Day1.yxzp

afv2688

Finally done not the most elegant but it works!

Spoiler

chandler-gjino

attaching my solution for day one

CG 12.01.23.yxmd

phottovy

@starkey, adding containers was a nice touch to hide that we secretly worked together!

MeganBowers

Spoiler

I am impressed with some of the regex solutions for part 2 on here. I hardcoded mine for part 2, but it took a while to find all the exceptions!

Screen Shot 2023-12-01 at 9.17.01 AM.png

Screen Shot 2023-12-01 at 9.17.01 AM.png

SeanAdams

Great start to AOC - I feel like I cheated a bit, but going to have a look at how other people did it.

Spoiler

Recipe here is a bit of a cheat:
- Take each number (written in text and in numbers) in a text input. screenshot 1
Screenshot 2023-12-01 113216.png

- do a cross-join with the test data so that every data row joins to every number
- then check for the first instance of the number ("one") in the text
- then reverse the test data and the numbers and look for the first instance of the number ("eno" - reversed "one")
- now you have the last and the first instance of numbers in the string

Why this way?
- it avoids the issue of numbers that share letters like "oneight"
- given you only want the first and last - you don't need to worry about every instance
- Finding the first instance is easy in Alteryx, finding the last is a little tougher, so reverse the strings and then it all becomes "find the first"

Screenshot 2023-12-01 113632.png

2023_Day11-Part2.yxzp

The_Rad_Valentina

The second part was indeed confusing, but we got her solved.

Day1.png

The_Rad_Valentina

Second part was indeed confusing but we got it done.

Day1.png

ccanterman

Complete! I borrowed @Tokimatsu's RegEx Replace after my RegEx Replace formulas missed the stupid Part 2 trick

The ReverseString idea from others was genius!

Spoiler

geoff_zath

That was a fun one!

Spoiler

advent_2023_day1_GKZ.yxmd

mbarone

My first every AOC attempt "for real" (did one last week to go over in a UG). Didn't get to it until this afternoon, but **bleep**, that second part was a pain! Tried several things but they were hardcoded and I hated that, so I finally came up with a dynamic way using append. Fun fun!

Spoiler

Day01.yxmd

StevenP

Managed to complete part two with a little rework on my matching list

Spoiler

Gem

I'm so excited about this!

Spoiler

Day 1.yxmd

alisonpitt

I feel like there's an easier way to do this but I got there eventually! 😊

Spoiler

For part 2 I went the route of finding all the number numbers and word numbers by position, extracting them and putting them back in order before going back to the same workflow as in part 1. This one took a couple tries because I missed 1) the overlapping word numbers, 2) regex won't catch both 'one' and 'two' in twone just using one|two 🙃 Every day's a school day!

Day 1 - AP.yxmd

alisonpitt

I feel certain I did this the hard way but it's fine 😅

Spoiler

Day 1 - AP.yxmd

JeffF

Spoiler

Watermark

2nd part was tough

Spoiler

AOC 2023 Day1.yxmd

Gawa

Revisiting this problem, enjoy playing tool-golf. 5 tools.

Spoiler

AoC2023_Day1_golf_gawa.yxmd

IraWatt

Overlapping numbers 🤢 - took me a while to figure out I didn't know how many letters there are in Three, got there in the end.

Spoiler

Day 1.yxmd

CandiceDB

Part 2 took a minute but finally there! My solution 😊:

Spoiler

Day1_CDB.yxmd

keylyn

Part 2 took a while!

Spoiler

Finding the possible number combinations was tricky! I happened to notice the "oneight" in the example, otherwise I think I would have really struggled to figure it out! Day 1 Screenshot.jpg