This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This was a really fun challenge! Great for learning more about Regex!
My solution! So happy I could do something World Cup-related that would save me from mourning over England's loss to Croatia at semi-finals today. Football isn't coming home just yet...
12 tools, I'm satisfied:)
I need to get better at regex and not text to columns haha
Bit late, but got it :)
Here is my solution
I have a run time of 1.6 seconds VS Alteryx solution of 2.8 seconds. First time I beat the run time
I like @danrh and @EstherB47 (and whoever else did it) method of concatenating first. Nice trick.