Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_Hartmann
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
marcus_sommer

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
crusader_
Partner - Specialist
Partner - Specialist

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

Frank_Hartmann
Master II
Master II
Author

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

marcus_sommer

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