In a field(say htmlfield varchar(200)) in the table(mytable) i have some data in the format shown below.
<b>Label A</b><br>Some Label<br><b>Label B</b><br>Need This value<br><b>End Look</b><br>The value - between this is what i want<br>
i need a query to extract the value between the second br tags thats
"Need This value"
and the third br tags that
"The value - between this is what i want."
What am actaully trying to achieve is to display only the relevant data to the users in the excel sheet ( Am using the new database query option available in excel to connect to SQL Server 2000).
I cannot change the way the data is inserted. Neither can i do any datatype changes.
Thanks for any help.
I have seen http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=197&lngWId=5
but i dont think this will work when i use it from excel.