hellos all
I would appreciate your help on the following issue:
I have a html source extract where each line is separated by <li>...</br> tags, this extract is copied into cell (E.g) A1 . Data between the tags is a combination of both numbers & text . Examples of how the data looks like:
E.g 1 :<li> 3.3=weight(Content:test in 333), breakdownof:</br>
E.g.2 :<li>7=freq(doc=2, factor=3.3)</br>.
E.g.3 : <li> 4.5=fieldfact</br>
What i am trying do is :
1- divide the entire extract into lines based the <li>..</br> add to a matirx perhaps?
2- for each line (for each <li>..</br>) extract numbers & strings to be able to do further analysis.
so far e.g for Eg1&Eg 2 i would want to see :
weight Content in freq doc factor fieldfact 3.3 test 333 7 2 3.3 4.5
i hope my explanation was clear , i am trying to use the "Microsoft VBScript Regular Expressions 5.5" , i would really appreciate your help on this issue since i am fairly new with VBA !!
Many thanks
Zeek
Bookmarks