This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Regex to the rescue...
Very similar to the both of you and I think I've made more iterative macros this month than I ever have in day to day Alteryx use!
Also a "bit" of regex... I used two iteratives: one to generate rule 0 and another to beautify the regex expression (remove extra brackets).
The same workflow works for both parts, after manual update of the rules... It took me a lot of trial and error to get it working for the updated rule 11. But regular-expression.info to the rescue.
Final Regex
I'm not sure I understood everything I did about Regex but eventually I got there, discovering recursive regex on the way.
@dsmdavid lovely recursive regex I'd have never have worked that out