Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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