Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADefinetly not the optimal way but here is my solution
Got to practice some Regex, which is always appreciated.
A great case scenario using RegEx, for this exercise I was able to resolve only using RegEx and forms
My Solution:
Thank you for the great challenge. REGEX has not been a strongpoint of mine so it was a great learning experience. I had first tried to use REGEX within the formula tool to avoid creating extra columns, but had trouble making that work so I went forward with the REGEX tool.