Hi, I'm looking for an approach to read all the content inside an HTML tag with an ID that I derive dynamically in the workflow. Eg. ... ... ... ... A solution somewhat similar to the regex -- .*? (not working), that generates the output; --- ... --- And eventually the goal is to extract and list out the contents. Could anyone provide some suggestions? Thank you in advance! html_file.txt

Parse all content between HTML tags using the element ID

Hi,

I'm looking for an approach to read all the content inside an HTML tag with an ID that I derive dynamically in the workflow.

Eg.

<HTML>

...

</DIV>

<DIV id="section-2" class="someclass" > ...

</DIV>

...

</HTML>

A solution somewhat similar to the regex -- <div class=\"someclass\" id=\"' + [DIV_ID] + '\" .*?>.*?<\/div> (not working), that generates the output;

---

</DIV>

---

And eventually the goal is to extract and list out the <table> contents.

Could anyone provide some suggestions? Thank you in advance!

html_file.txt

Regex

Parse

Accepted answers

CharlieS

How about a Join as a filter?

20180726-HTMLTableFilter.yxmd

All comments

BenMoss

Do you have some sample data @geeman

Ben

CharlieS

IF it's all on the same line/record, then you could use the substring function. Here's an example:

Substring([Field1],findstring([Field1],"<table>")+7,findstring([Field1],"</table>")-(findstring([Field1],"<table>")+7))

Otherwise, like @BenMoss said: an example input file for us to use would be best.

geeman

Thanks for the replies @CharlieS & @BenMoss! I have attached a sample file for your reference. The actual html file is a very large file that grows dynamically, when the Ajax calls are made to load additional data in the tables.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703