topic Re: extracting values from html sourcecode in QlikView

extracting values from html sourcecode

Frank_Hartmann — Thu, 29 Jan 2015 09:54:36 GMT

Hello QV Community,

I´m trying to extract some values from a Websites html sourcecode

the values i am interested in are always in between the same sourcecodelines:

and

</span><span

for example:

<td headers="ac" class="spot"><span class="rate">1.0242</span><span

how do i have to setup my script in order to get theses values from the html sourcecode loaded into a table?

thanks in advance for your help

Re: extracting values from html sourcecode

crusader_ — Thu, 29 Jan 2015 10:24:39 GMT

Hi,

Have you tried to import your web-page to QV app using standart "Web Files.. import wizard" in the Script Editor?

Can you give a web-page link for testing?

Regards,

Andrei Kaliahin

Re: extracting values from html sourcecode

Frank_Hartmann — Thu, 29 Jan 2015 18:14:49 GMT

Yes I know this possibility you suggested, but i want to know how to do it just with scripting.

I just want the script to run through every line of the sourcecode and search for the above mentioned conditions and

load theses values in a table

Any ideas?

I appreciate every hint

Re: extracting values from html sourcecode

marcus_sommer — Thu, 29 Jan 2015 18:32:24 GMT

The suggestions from Andrei Kaliahin to use the qv-wizard is a straightforward way to solve this case or at least to find a good starting-point (you will get a script-statement) for further changes or improvements.

I could imagine that you with this will find a solution. A rather worse alternatively could be to fetch this data with textbetween() and transform then this content.

- Marcus