Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Great challenge! We solved it in 2 ways - once with REGEX and again without
I love the RegEx Tool, especially for parsing, so I decided not to use the tool and instead use the RegEx functions in the Formula Tool - really helpful learning exercise
Solution attached below:
Not the most ideal solution but it works.