Regex HTML parse

[RMojsiak]

Hello everybody,

I would like to parse an HTML table, that is provided in the body of an email, which I extract with the Outlook 365 Beta Tool. I tried with the REGEX parse tool (and other tools), but I can't seem to find the right expression.

After looking at the extracted code I figured out that the headers are between <p class="MsoNormal"><b> and </b></p>
and the information is between <p class="MsoNormal"> and</p>.

Some of the expressions I tried: [<]p\sclass[=]["]MsoNormal["][>](.*?)[<]\/p[>]

"MsoNormal(.*?)[<]\/p[>] -> this pulls something through but not what I want

Maybe the answer is really easy, but I overlook it.

Happy Friday!

[PhilipMannering]

Hi @RMojsiak.

Are you able to share the html table in a Text Input or file, so that folks here can try and extract it the right text?

[mceleavey]

Hi @RMojsiak ,

As @PhilipMannering points out we can't really help fully unless we can see the HTML. However, I've put some basic regex structure together using the info you've provided.

The HTML looks like this:

And I've configured the regex as follows:

Then you just need to transpose/Crosstab and you're away.

M.

[RMojsiak]

I think I put all the code for the table. It should look like this.

[PhilipMannering · Accepted solution]

As much as I like regex, the XML Parse Tool should work better for parsing html. I'm still not sure exactly what you want to extract, but see the attached workflow as a potential starting point.

[RMojsiak]

It worked! Thank you so much. I did some tweaks to make it look nice. Can't believe it was so simple😊