Advent of Code 2020 - BaseA Style (Day 4)

Jean-Balteryx

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

Advent of Code

Accepted answers

All comments

Greg_Murray

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

Spoiler

jdunkerley79

Love the smell of RegEx in the morning...

Spoiler

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

AkimasaKajitani

My solution at Day04.

Using simple ToNumber function(Off course using RegEx_Match).

Spoiler

As anonymous user #1105310

Jean-Balteryx

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

cgoodman

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

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!

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

My Day 4..

Going in "basic user" mode...

Spoiler

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

NicoleJohnson

Definitely well suited to Alteryx - always love a good parsing exercise, especially if it includes a little RegEx!

Spoiler

Solved this two ways - the first way for speed of star gathering, of course... the second way, because the whole time I was doing it the first way I was thinking "this would be a fun excuse to use the Dynamic Formula CReW Macro tool that I never can find good opportunities to use..." - and I was right!

Method 1: An exercise in the Favorites tools.

Method 2: Dynamic Formula for the 8-tool win! (Not sure that actually counts as 8 tools since Dynamic Formula is a macro... but whatever.)

Cheers!

2020_Day4_Alternate.yxzp

2020_Day4.yxzp

patrick_digan

My regex wasn't pretty, but I did get the right answer the first time (so I got lucky)

Spoiler

T_Willins

Day 4

Spoiler

AOC 20.4.yxmd

joshbennett

I really enjoyed this one!

Part 1 and Part 2:

Spoiler

Part 1:

Spoiler

Part 2:

Spoiler

AdventofCode_2020_Day4.yxmd

OllieClarke

And here's day 4

Spoiler

Probs not best practice to write a single IFTHEN filled with RegEx to get the valid/invalid Day 4.PNG

Day 4.yxmd

estherb47

Somehow I lost my workflow for this one. Posting this as proof that I got both stars

Edited. Rebuilt the workflow the same way I did the last time. Too many tools, and runs in only 0.6 seconds.

Shrink the data set filter by filter so everything runs faster (lessons from @MarqueeCrew and @Deanna via InspireEU in 2019!)

Spoiler

peter_gb

Day 4 | Remembered regex

Spoiler

AoC4_pgb.yxmd

KaneG

I've just caught up with the first 4 days. I'm not sure if it's because of my role (Instructional in nature) or not, but I always tend to use more tools if it makes it clearer.

I used a text input with REGEX validation criteria, same as I would if I was validating all the fields in an incoming file for instance.

Spoiler

Part 1:

Part 2:

Text Input for Validation:

Day 4.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703