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 REPLIES 18
Greg_Murray
12 - Quasar

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

Spoiler
Greg_Murray_0-1607061065975.png

 

jdunkerley79
ACE Emeritus
ACE Emeritus

Love the smell of RegEx in the morning...

Spoiler
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).

 

Spoiler
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 !

 

Spoiler
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.

 

Spoiler
cgoodman3_0-1607073633025.png

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
davas
7 - Meteor

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.  

 

Spoiler
danilang_1-1607088404698.png

 


 

Dan

NedHarding
7 - Meteor

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... 

Spoiler
aguisande_1-1607093731373.png

 

 

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

Labels