Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAGreat RegEx practice, but I would've never figured this out how to use the RegEx without the solutions from others here!
Also shout out to @JORGE4900 -- that link is a great help!
Good regex fun. Probably not easy to debug though --having all the parsing in just one tool. but...
(\d{7})(.*?)\s([\w\-]+)\s\((\d{4})\)\sCAT\:([\w\-]+)\sPUB\:([\w\-\s]+)[^\$]+?\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)
Not a fun of how the tool "forgets" the names that you had labourously typed everytime you forget then remember a missing bracket. Quite useful to edit in the xml window in those cases.
Easily the longest attempt I've sat through for a weekly challenge...
Used https://regexr.com to expedite but had to review my regex expression against other's solutions repeatedly to investigate broken points.
Would be lovely if regex can be friendlier to us. 😛
If you find that the Regex experience can be improved, you may want to like this idea here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/RegEx-let-s-make-it-easier/idi-p/75238