Challenge #289: Prep a Shoe List

[BS_THE_ANALYST]

I think the solution could be improved as per the task requirements 'clean the inventory data'. There are 5 duplicates in the dataset which need to be removed.  

I was thinking how we could enrich this problem aswell. What if we have a list of standard colours, and we count the instances of that list against our shoe record colours. Could be a fun problem.

[lucascs]

solved

[fsnunes]

Solution

[annbriceAB]

I tried to use this expression in RegEx: (.*)/(.*)/(.*)

But it would only parse the first two columns.  I think I needed something to tell it the 2nd and 3rd columns were optional, but if anyone has an idea, please let me know.

This was a fun challenge, thanks!

[lucysinclair62]

Had to change it to the british spelling lol

Spoiler

[mkorpi]

My solution!

[alt_marsan]

Howdy! Nice easy practice!

[Verakso]

Fun little challenge, here is my take at it

Spoiler

/Verakso (ツ)

[JanellaShu]

Spoiler

[RobbieA]

289 Solution: