topic Read local HTML file in Talend Studio

Read local HTML file

Anonymous — Thu, 18 Feb 2016 12:55:10 GMT

Hi!
I should parse and save data from .xls files. But I can't use standart component tfileInputExcel, because these files are in html format. I opened file with "notepad" and it conteined html tags
".c155 {border-width: 0.5pt;border-color: #000000;border-style: solid;width:2.086%;background-color: #ffffff;}
.c156 {border-width: 0.5pt;border-color: #000000;border-style: solid;width:2.045%;background-color: #ffffff;}
.c157 {border-width: 0.5pt;border-color: #000000;border-style: solid;width:2.139%;background-color: #ffffff;}
.c158 {margin-top: 0.0pt;margin-bottom: 0.0pt;margin-left: 0.6pt;margin-right: auto;width: 1589.15pt;border-collapse: collapse;}
</style>
</head>
<body>
<table class="c10">
<tr class="c0">
<td valign="top" class="c1"> 
 
</td>
<td valign="top" class="c3">DATA
 ..."
I've found how to read html-tables from web-site ("http://www.rilhia.com/tutorials/using-third-party-java-library-scrape-content-table-web-page"). But I should work with local file.
Please, help me!
Thanks!

Re: Read local HTML file

Anonymous — Mon, 22 Feb 2016 03:46:02 GMT

Hi,
Have you tried to create file xml in metadata to read your xml files? What does your expected output look like?
Best regards
Sabrina

Re: Read local HTML file

Anonymous — Wed, 02 Mar 2016 13:03:36 GMT

Hi!

I use tHTTPTableInput component to solve my problem.

tFileInputFullRow------------>tFileOutputDelimited
|

| onSubjobOk

tHTTPTableInput------------>tLogRow

I read my .xls file (tFileInputFullRow) into "D:/tmp/DailyStat.html" (tFileOutputDelimited)

And tHTTPTableInput reads from URL ""file://localhost/D:/tmp/DailyStat.html"" with "Syntax for Table : T=1" my html table
Thanks!