Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parse all content between HTML tags using the element ID

geeman
8 - Asteroid
‎07-26-2018 12:27 PM

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 id="section-1" class="someclass" > <table><tr>...</tr></table>

</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 id="section-1" class="someclass" > <table><tr>...</tr></table>

</DIV>

---

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

 

Could anyone provide some suggestions? Thank you in advance!

 

 

Preview file
1 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

7 REPLIES 7
BenMoss
ACE Emeritus
ACE Emeritus
‎07-26-2018 12:55 PM

Do you have some sample data @geeman

 

Ben

Reply
0 Likes
CharlieS
17 - Castor
17 - Castor
‎07-26-2018 01:08 PM

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.

Reply
geeman
8 - Asteroid
‎07-26-2018 01:20 PM

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.

Reply
0 Likes
CharlieS
17 - Castor
17 - Castor
‎07-26-2018 01:45 PM

I'm not sure exactly what you're looking for as far as table parsing goes, but I've attached a solution that will isolate the table contents with the section name appended.

20180726-HTMLTables.yxmd
Reply
0 Likes
geeman
8 - Asteroid
‎07-26-2018 02:00 PM

Hi @CharlieS, this is close to what I'm looking for.. the only additional ask is to be able to pass the html element id (Div id, in this case) as variable/parameter to the Multi-Row Formula dynamically.. Thank you so much for your help!

 

Reply
0 Likes
CharlieS
17 - Castor
17 - Castor
‎07-26-2018 02:10 PM

How about a Join as a filter?

20180726-HTMLTableFilter.yxmd
Reply
0 Likes
geeman
8 - Asteroid
‎07-26-2018 02:16 PM

@CharlieS, Thank you, Appreciate your help!...  actually I thought about putting a filter for the specific 'Sections' and it works similar to the join you suggested.

But again is it possible to pass a parameter in the Multi-Row Formula?  The table content needs to be only from section-1, in your solution it is getting the table content for both section-1 & section-2. This is the reason why I was looking for getting only the section-1 block. Any suggestions?

Reply
0 Likes
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All