local html file

[Hanspeter]

Hi, I am a new user and need some help. My datasource is an HTML file on my computer (please see the attachment - file type .htm - I zipped the file in order to upload it here), but so far I failed to access the data. I am thankful for any help! There are some other similar discussion posts here but none really helped me.

[joshuaburkhow · Accepted solution]

Hi @Hanspeter 

I have given you a start to see how I would get started. You can modify the RegEx and/or Add multiples to account for the <tbody> tag the <tr> tag and the <td> tag. 

Hope this helps!

[Hanspeter]

Thank you very much, Joshua. This is exactly what I needed.

(Even though I realize now that the remaining steps are not as easy as I hoped it would be - coming from Power Query which is so much easier.)