Challenge #121: World Cup 2018!

[danrh]

8 tools with regex :)

Révélation

Ironically, my first two tools concatenate the data rather than parsing.

[patrick_digan]

@MarqueeCrew I'm turning in my weekly assignment.

Révélation

I used a few more tools than I wanted since there's no multi-row multi-field tool built in.

[MarqueeCrew]

Révélation

My solution with a special shoutout to @NicoleJohnson for solving with fewer tools than I did.  I went above and beyond to be unique.

Cheers,

Mark

[MarqueeCrew]

@patrick_digan,

Fewer tools than @NicoleJohnson.  Nice work.

Cheers,

Mark

[ponraj]

Here is my version of solution. 

[estherb47]

Had fun with this one! Started down my usual path of removing null rows, assigning a record ID, and using Make Columns, but decided that @NicoleJohnson and I shouldn't be using the same methods week after week. So, went down another path.

7 tools. Added in @MarqueeCrew's checking tool to verify my solution. Thanks Mark!

I would like to include the images in a lovely report, but I'm struggling with some of them not downloading correctly. TBC when I get those all working. But for now....

Révélation

[mjholland]

Mine feels a little messy, there are loads of text to column tools used here and I'm sure it's not the most efficient. I really struggle with Parsing and RegEx. But I got there in the end.

Révélation

[ggruccio]

Got to the matching output fairly quickly.

Then added an optional report that combines the schedule, photo, and caption for each stadium.  (see example in spoiler tag)

Révélation

Report Example

[DawnR]

Getting the hang of some Regex_Match formulas.

[ansari]

Hi, here is my solution...!!

Révélation