Great news--we have a new guide with loads of content on text parsing problems: Text Parsing Guide
If you have questions about using the Text to Columns, Formula, JSON Parse, XML Parse, or RegEx tools, this guide is for you. There are lots of resources, including videos, blog posts, and discussion threads, synthesized to help you develop your text parsing skills.
p.s. if you haven't seen our other content guides, here are the links:
Alteryx & Excel Guide