Weekly Challenge

(\d{7})(.*?)\s([\w\-]+)\s\((\d{4})\)\sCAT\:([\w\-]+)\sPUB\:([\w\-\s]+)[^\$]+?\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)

(\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.

Spoiler

kylemhabe · ‎03-20-2020

Spoiler

Carlithian · ‎03-20-2020

loved this challenge, gave myself and extra challenge of parsing it with a single regex formula 🙂

Amin · ‎03-20-2020

Spoiler

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. 😛

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

Weekly Challenge

IDEAS WANTED

Challenge #207: Parsing Video Game Data