thanks kadghar for your reply
So can we use xml to read data from html,is it possible and how perfect it will be ,can you explain me little more in detail.
well, sure, it wont be that easy, but it can be done,
for example
lets say you have a Table, i dont remember the exact tags, but lets asume <Table> </Table> start and close the table, that <row></row> start and close a row, and <col></col> start and ends a column, and your data is written like:
<table>
<row><col>a1</col><col>a2</col></row>
<row><col>b1</col><col>b2</col></row>
<row><col>c1</col><col>c2</col></row>
</table>
so it looks like:
a1 a2
b1 b2
c1 c2
if your HTML code is in a string (lets say Str1)
then INSTR(str1,"<table>") will return a Long, with the starting possition (lets call it Dou1)
INSTR(Dou1, Str1, "</table>") will give us the ending possition (say Dou2)
using MID from Dou1 to Dou2 will give you the code for where your data is.
using SPLIT a couple of times will put this data into an array (actually an array of arrays, but its not big deal)
HTH
Kad
Note: i forgot, i think split only works with characters as delimiters, so you might have to use REPLACE to change the tags with some delimiter of your choice.