Dear challengers!
Ready for the new RPA challenge? I hope you do because this one is a delicate one!
Goal of the challenge
The internal system got crazy and mashed the injuries report file into one big mess. Only a few rows remained in the correct format. First and second. And from the third one, the system went crazy. Cells got mixed in every possible order. Thankfully, only horizontally, so each row still belongs to one listing.
The goal is to repair the Excel table structure.
If you are good with regex, then this should not be a complicated challenge for you. You can solve it also using some basic string methods! The main task is to find a way how to recognize in what column the value goes. Think about patterns that are specific for each column.
Input data
corrupted.xlsx (11.5 KB)
Outputs
Use the pattern from the corrupted file headers to create a new one with cells in the right places.
Challenge difficulty: harder.
How to participate
When you are happy with your robot:
- post output file here
- send .xaml (or another source) file as a private message directly to me (click my profile picture → Message)
First three correct, original solvers earn 3 robopoints, next get 1 robopoint.
I will hold a leaderboard with your score and update it. Those on top positions will be badged by a special challenger badge 
The challenge deadline is 2.5. by the end of the day. You can still submit your projects after the deadline but you cannot earn robopoints. A new challenge is published every week or 2 weeks so don’t worry if you did not catch this one. Keep in mind, your submitted files may be published after the deadline so others can learn from solutions.
PS: Are you having specific trouble with your other projects? Do not hesitate to Ask in our Ask category!
