General Discussions
Discuss any topics that are not product-specific here.
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!
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
- 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"
Recipe here is a bit of a cheat:
- Take each number (written in text and in numbers) in a text input. screenshot 1
- 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"
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!
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!
