Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFigured it was finally time to learn about XML. Not as bad as I thought!
my solution :) basically regex only
also left the complete regex sequence for a one-step tokenize in there in an inactive container.
It works in regex101 with the samples, but doesn't work in alteryx - it does not seem to like "\n*.*\n*.*\n*.*\n*.*" somewhere in the expression and gives an error...
(RegEx (64) There was an error in regex_search The complexity of matching the regular expression exceeded predefined bounds. Try refactoring the regular expression to make each choice made by the state machine unambiguous. This exception is thrown to prevent "eternal" matches that take an indefinite period time to locate.)
the workaround was just tokenizing twice and joining afterwards as seen in my solution
My solution.
Did it without XML parse which is probably not ideal. Went into VS Code and considered the regex required to capture the key value pairs.