Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAYou have a source system that doesn't seem to be working quite as expected. The system will frequently take any given word and duplicate it within a string. You job is to clean it up! Below we have a few sample phrases that are indicative of the system's problem. Find all words that have duplicate consecutive words and reduce the duplication to a single word again!
(Advanced Users: There is a one tool solution for this!)
REGEX_Replace([Phrase], '(^|[ ])(.*) (\2)', '$1$2')
Here is my 1 tool solution.
Learning RegEx so it's helpful to see examples of how it all works.
Solution attached.