Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Master II
Master II

extracting values from html sourcecode

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:

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


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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

View solution in original post

3 Replies
Partner
Partner

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

Master II
Master II

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

MVP & Luminary
MVP & Luminary

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

View solution in original post