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

[Roche]

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

[atcodedog05 · Accepted solution]

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 : )

[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.

M.

[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