How do I load the HTML code from a website to a table? I saw the following script provided in another older thread, but I get an error when trying to run it.
html:
LOAD RecNo() as Rec,
@1:n as Line
(fix, utf8)
;
NoConcatenate
html1:
Load
*
Where Line <> '>'
;
Load
RecNo() as Rec,
subfield(Line,'>') & '>' as Line
Resident html
Order By Rec
;
NoConcatenate
html2:
Load
*
Where left(Line, 1) <> '<' and len(trim(Line))>0
;
Load
Rec,
if(Right(Line,1)='>' and Left(Line, 1) <> '<', '</' & Line, Line) as Line
;
Load
Rec,
subfield(Line,'</') as Line
Resident html1
Order By Rec;
drop tables html, html1;
Any solutions to read a web page to table? I note that the docs on the Load advise loading from a webpage is possible?
