It's beginning to look a lot like...Advent of Code! Get in the holiday spirit by learning how you can participate in this friendly competition and earn a seasonal badge.
Weekly Challenge
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
Done! Used Regex as well:
Spoiler
For anyone curious: ^(.*?)\s*~\s*(.*?)\s*([A-Z]{2})(?:\s*(\d{5}))?$
An almost exlusively RegEx solution from me
With bigger dataset (and more cases or roads, circles, streets, etc) it would be better to use lookup table instead Formula with Replace functions
