Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThe hardest part was finding the original post to reply to! 😁 I did this dynamically for headers, but it still seems a little long. I parsed headers and data separately, maybe I could have combined?
oversimplified solution without dynamically found headers and/or length of the field, but still fun 🙂
Props to @PhilipMannering, @BeginnerMindset, @Luke_C, @Harshal_S, @TonyA, @CatheyH, @OllieClarke, @Maskell_Rascal, @JP_SDAK, @Ladarthure (apologies to anyone I missed) for attempting to solve this challenge with a dynamic solution!
I enjoyed dynamically calculating a ReGex expression to split based on the number of dashes but could never quite figure out how to use the expression in the RegEx tool. Here is a different approach with an iterative macro.
Kind of dynamic, depending how much invoices change...