Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA8 tools with regex :)
@MarqueeCrew I'm turning in my weekly assignment.
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
Fewer tools than @NicoleJohnson. Nice work.
Cheers,
Mark
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....
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.
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)
Hi, here is my solution...!!