Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAParsed the headers into rows for the dynamic replace. Split the doubles first, then used Regex in the formula tool to create the other fields. Multi-column formula with ignore errors instead of replace().
Practicing for Advanced exam, regex part. A wonderful challenge to hone my skill.
worked hard.
Tried to not use regex and ended up with lets just say what an only be described as an extended workflow. Regex next time for sure.