Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI came up with two solutions. In my first solution I used a Text Input tool and fed that into a Find Replace tool.
In my second solution I used a Formula tool and the REGEX_REPLACE String function to replace specific character strings. After that, the remaining tools were the same used in the first solution.
I did not figure out how to change the flow from top to bottom.
All,
This one took me a bit.
Thanks!
Matt
Solution attached 🙂
Fun throwback and functionality that I had no idea was there.
Solution very inline with others.
-Used pattern as delimiter to split to rows
-Filtered on 'atm2.'
-REGEX to get to number format