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

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