Regex HTML parse

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 and 
and the information is between and.

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!

Parse

Transformation

Accepted answers

philipmannering

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.

extract data from table.yxmd

All comments

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.

mceleavey regex.yxmd

RMojsiak

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

HTML.txt

philipmannering

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.

extract data from table.yxmd

RMojsiak

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703