ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   web and excel find text string... (https://www.excelbanter.com/excel-programming/362019-web-excel-find-text-string.html)

sal21

web and excel find text string...
 
I have this page in html...

How to find the value 1 and 4 in:

<td WIDTH="25%" ALIGN="center"<font style="font-family: Verdana,
Arial, Helvetica, sans-serif; font-size: 10px; font-weight:
bold"&nbsp;Pagine&nbsp;1&nbsp;di&nbsp;4&nbsp;</font</td

and to find the value 308:


<td align="center" colspan="11" class="INFO"Totale fidi individuati:
308<br</td

after store the value founded in var_1, var_4 and var_308


Tim Williams

web and excel find text string...
 
Where is the page?
Loaded in a browser?
In a text file?
The content of a variable?

How to "find" the value is a different question.
Are you always getting the value from the same table cell? If so and the page is loaded in IE then you can get a reference to the
cell and then to its innerHTML or innerText property. From there you could parse the value to extract the values.

Tim

"sal21" wrote in message oups.com...
I have this page in html...

How to find the value 1 and 4 in:

<td WIDTH="25%" ALIGN="center"<font style="font-family: Verdana,
Arial, Helvetica, sans-serif; font-size: 10px; font-weight:
bold"&nbsp;Pagine&nbsp;1&nbsp;di&nbsp;4&nbsp;</font</td

and to find the value 308:


<td align="center" colspan="11" class="INFO"Totale fidi individuati:
308<br</td

after store the value founded in var_1, var_4 and var_308





All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com