topic Extracting tables from web output in Talend Studio

Extracting tables from web output

Anonymous — Sat, 16 Nov 2024 09:36:34 GMT

Hi, all!

There is a website with tables (tag <table></table>. How to extract table data to rows from tHttpRequest output (string)?

Regards

Re: Extracting tables from web output

Aukema — Tue, 20 Jun 2017 13:48:35 GMT

You could try using regular expressions, however best-practice is to use a parser like JSOUP.

I would go for the parser in combination with tLibaryLoad and tJavaFlex

Re: Extracting tables from web output

Anonymous — Tue, 20 Jun 2017 14:07:51 GMT

I've written a tutorial on this very subject. The example job is included. You might be able to download the job and configure it to your requirements

https://www.rilhia.com/tutorials/using-third-party-java-library-scrape-content-table-web-page

Re: Extracting tables from web output

Anonymous — Tue, 20 Jun 2017 14:58:52 GMT

Thank you! It works!

Re: Extracting tables from web output

Anonymous — Tue, 30 Jul 2019 15:11:12 GMT

Unfortunately the tutorial is no longer available. However this post covers everything in the tutorial.....
https://community.talend.com/t5/Design-and-Development/Extract-Multiple-table-using-tHTTPTableInput-component/m-p/155366