extracting values from html sourcecode

[Frank_Hartmann]

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

[crusader_]

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]

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 · Accepted solution]

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