Parsing local HTML file to extract data from specific headers

Question

Hello,

Help needed!

I have a set of offline HTML files and I need to extract information from some specific headers for each file

How can I do this?

when I use the download tool I get an error as it a local file

I tried opening as CSV in the input tool which shows HTML code but I am not sure what to do next

KilianL · Answer

Great to hear!

To wrap it up, in Alteryx, you can use RegEx with the RegEx Tool, and we also have a couple of RegEx functions to use in formulas.

If you need an example with your data, I am sure the community can help you 🙂

aluthra · Answer

Thanks @KilianL

I think the time has come to explore RegEx :-). I will give it a go.

KilianL · Answer

Hello @aluthra,

You might be able to avoid RegEx depending on how complex your parsing problem is.

Text functions like left(), right(), contains(), or the text to columns tool can do a lot of basic parsing.

You can always use Python, and then your possibilities are nearly endless. But for text parsing RegEx is the gold standard across programs, including Python.