General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2020 - BaseA Style (Day 4)

Jean-Balteryx
16 - Nebula
16 - Nebula

Discussion thread for day 4 of the Advent of Code : https://adventofcode.com/2020/day/4

18件の返信18
Greg_Murray
クエーサー

This was a fun one! Nothing like a little regex in the evening. 

スポイラ
Greg_Murray_0-1607061065975.png

 

jdunkerley79
ACE Emeritus
ACE Emeritus

Love the smell of RegEx in the morning...

スポイラ
jdunkerley79_0-1607062640884.png


Decided to go for pure Regex validation - no tonumber-ings

jdunkerley79_1-1607062664873.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution at Day04.

 

Using simple ToNumber function(Off course using RegEx_Match).

 

スポイラ
AkimasaKajitani_0-1607063776502.png

 

As anonymous user #1105310

Jean-Balteryx
16 - Nebula
16 - Nebula

Day 4 solution. Not that much Regex but one big filter for part 2 !

 

スポイラ
2020-12-04 08_33_51-Alteryx Designer x64 - AOC_2020_Day_4.yxmd.png
cgoodman3
14 - Magnetar
14 - Magnetar

Day 4 - Tried to do it with no regex, but used a regexcount matches as I didn't write out a really long 

substring([Field_1],2,1) IN ("0","1","2"..."a","b","c"...) for validating the hair colour.

 

Also the many filters helped finding the typo much easier than trying to next it to bring the overall tool count down.

 

スポイラ
cgoodman3_0-1607073633025.png

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
davas
メテオール

Managed to get the right answers but it's clear i need to brush up on my regex syntax 😀

 

It's really great looking through how different people solve things! 

danilang
19 - Altair
19 - Altair

Regex is definitely the way to go here.  Kudo's to @cgoodman3 for trying to solve it without using the regex hammer.  

 

スポイラ
danilang_1-1607088404698.png

 


 

Dan

NedHarding
メテオール

Day 4 was interesting and very well suited to Alteryx.  Actually probably easier in Alteryx than in a normal programming language.

 

If anyone wants my solutions, I put them here:  https://github.com/NedHarding/Advent2020

 

 

Aguisande
15 - Aurora
15 - Aurora

My Day 4..

Going in "basic user" mode... 

スポイラ
aguisande_1-1607093731373.png

 

 

BTW... I'd love to see those Regex Expressions you (all) used later... 

投票
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
ラベル