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

[Steph_Maddrell]

I went for some validation within the regex and some in the filter - see the giant custom formula in the filter tool at the end! This one definitely helped my regex skills.

Spoiler

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

NJ

[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

[joshbennett]

I really enjoyed this one!

Part 1 and Part 2:

Spoiler

Part 1:

Spoiler

Part 2:

Spoiler

[OllieClarke]

And here's day 4

Spoiler

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

[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

 

[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: