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.
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:
Great content! A good share of the topics here are about parsing, so this will be very useful for sure :)
I would only add that (at least for me) some external tools can help a lot to work with regex/json/xml before doing it on Alteryx, hope they are useful for someone else that dont know them yet:
test regex expressions: https://regex101.com/
understand the json structure: https://jsonformatter.org/
understand the xml structure: https://jsonformatter.org/xml-formatter
Thanks for this. I shared it with our company!