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.
Here is my contribution
Here is my solution...
Here is my version. it is a long way but at the end achieved it.
Not the cleanest by any means
Finally made it. I really need to get a better handle on regex that middle expression in the parse tool took me way too long.
This is my first post here, not sure if i'm doing it in right place. I tried to workout a solution with minimum tools.
I'm lucky that in that I normally work from a data warehouse, so I generally don't have to do this much data cleansing. Therefore I'm sure I didn't come up with the best solution, but I did get there.
This was my first experience doing a deep dive into the reporting tool set! This was a fun one!