Webscraping, JSON file, links in table not extracted and some name descriptions truncated

Hi everyone,

I need some help to understand how to get the links in column 3 to display in the parsed data (using xml parse or if there is another way to do this). The website is F5 platform lifecycle support policy

I also find that the xml parse displays only a part of some of the column headers.

Can someone please help me with these problems?

I also attach the flow.

Thank you,

Rouche

webscrape_f5_table1.yxmd

Tips and Tricks

Parse

API

Accepted answers

atcodedog05

Hi @Roche

Parsing would need to be done something like below

Please look into the workflow and let me know if you have questions.

Hope this helps : )

webscrape_f5_table1.yxmd

All comments

atcodedog05

Hi @Roche

Parsing would need to be done something like below

Please look into the workflow and let me know if you have questions.

Hope this helps : )

webscrape_f5_table1.yxmd

mceleavey

Hi @Roche ,

I took a similar approach to @atcodedog05 , and used the parsing tools to cut out the bits you need, rather than relying on the XML structure being correct.

My approach is slightly different regarding the URL being shown, which I think is the problem you're having, and that's because the URL itself is outside the HTML tags, and so only the display text was being parsed.

I separated the header lines from the content, parsed them independently, and unioned back together on position:

This gives the URL it's own parse, and so returns this value:

Like I said, similar to @atcodedog05 but just handles the URL differently.

webscrape_f5_table1_mceleavey.yxmd

Roche

Hi @atcodedog05 and @mceleavey , thank you for the solutions. Both solutions gave me very useful insights. The solution I decided to use is @atcodedog05 since what I needed in JSON_Valuestring3 was the actual date that was entered as a link and not the actual link. Thank you very much to both of you. I appreciate your help a lot!

atcodedog05

Happy to help : ) @Roche

Cheers and have a nice day!

Roche

Thank you Same to you

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703