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

[phottovy]

The hardest is on day one right?!?

Spoiler

Reverse strings for the win. My solution only works with the first and last but wouldn't work if you had to identify every number.

[patrick_digan]

2 stars down, 48 to go!

Spoiler

Similar to others my first go at part 2 was incorrect. I looked at his sample with eightwo, and I decided that I would match his sample answer if I replace the numbers but also keep the first and last character (ie two = t2o, eight = e8t). so eightwo becomes eight2o and then replaces the eight to get e8t2o

[Ladarthure]

My solution, did not enjoy the regex I had to build but yes!

[rachel_k]

Spoiler

Used the Data Cleansing tool instead of regex to strip out all of the text - but hardcoded part 2

[lexi_westendorf]

Part 2 threw me for a loop! Ended up just inputting the possible overlappings in my lookup values, since there weren't that many possible combinations. Excited for tomorrow!

Spoiler

[estherb47]

Was not expecting the misfits on day 1

And when I started to think of the myriad of combos of digits, I didn't want to go brute force with a find replace.

So, I went brute force with 9 formulae.

Won't be doing the midnight drop tonight because Shabbat. So a little catch up right off the bat.

Spoiler

First attempt I put the digit at the beginning of the word. That caught more of the misfits, but not all. 

So then I tried putting it in the middle. Bingo!

IIF(Contains([Field1], "one"),REPLACE([Field1],"one","o1ne"),[field1]). Rinse and repeat for all the digits.

[estherb47]

Loving the use of regex in this one!! Seems my brain doesn't regex at midnight....

[Kenda]

Spoiler

already going with the brute force method with part 2 with the lookup table

[FrederikE]

It's finally that time of the year to be stressed out by daily challenges again 😅

Spoiler

 

[AkimasaKajitani]

My 1st workflow was very redundant. So I remade it with a cool head.

Spoiler

 

 And I tried to make it using Designer Cloud.

Spoiler

I can't reproduction my workflow in Designer Cloud because there is no first and last option at Summarize tool. So I adopted the @NicoleJ 's Idea(Data Creansing tool)