Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get HTML Source


Hi everybody,
does anyone of you, how do I get the HTML code from a Web-Page.

I try this:
myIds:
load

id,
name

from id...

LET Rows = FieldValueCount('id');

FOR i = 1 to $(Rows)-1

LET B = peek('name','$(i)', 'myIds');
LET A = peek('id','$(i)','myIds');

Please Note:
The TR Tag is thecontainer with the data I need.

<tr class="list"> ... </tr> Item 1
<tr class="list"> ... </tr> Item 2
...

Temp:
LOAD
'$(A)' as id,
TextBetWeen(@1:n,'<tr class="list">','</tr><tr class="list">') as source
FROM [http://www.mypage.de/search.html?q=$(B)] (fix, utf8);

NEXT

NewData:
LOAD

id,
TextBetWeen(source,'<td id="chart"', '</td>',1) as char1,
TextBetWeen(source,'<td id="float"', '</td>',1) as float1

RESIDENT Temp;

Drop Tables Temp;

1 Reply
Not applicable
Author

Hello and Happy new Year,

Does anyone have any idea how to realize it do?

sorry for my english