Challenge #121: World Cup 2018!

[TimN]

Hi,

My solution.  Learning regex ;)

[anthonyw]

My solution is attached. 

[ZacharyRyanTIL]

Spoiler

 
the less pretty solution

 

made a macro for this one!

[gerda]

Spoiler

this was fun to figure out 

[FinnCharlton]

Spoiler

[oliver_inthavong]

My (not so pretty) solution:

Spoiler

[AndrewHoData]

Used the formula tool to do a lot of functions I would have used separate tools for (eg Regex and DateTime). This was great practice for functions I was hesitant to use until now!

Spoiler

Just a note for future me in case I forget. The function to do Regex parsing using the Formula tool is:

Regex_Replace([String],"(The group we want in the regex expression)", "$1")

The "$1" is what tells it to choose the first group

[RamaJ]

Not the most optimal solution, but works just fine!

[JoachimCaronTIL]

Here is my solution

Spoiler

[alfredcsy]