Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Got stuck on the RegEx so had to get some help, but I learned from it (which I guess is the point of these, right?). Lots more clean-up than expected
Spoiler
Process
- Join three tables
- RegEx to parse title, year, and issue
- Clean-up and rename fields
- Replace title if it didn't come through in RegEx (where there was no publication year or issue)
- Clean-up nulls in Issue #
- Sort
- De-dupe
- Final clean-up
- Join three tables
- RegEx to parse title, year, and issue
- Clean-up and rename fields
- Replace title if it didn't come through in RegEx (where there was no publication year or issue)
- Clean-up nulls in Issue #
- Sort
- De-dupe
- Final clean-up
Didn't put much effort into addressing the ~2k difference in record, but it looks like many people had difficulty here.
The solution on the post shows an even much larger difference which I found strange.
