i have written one function, function name fn_parsehtml.
function fn_parsehtml as follows
CREATE FUNCTION [dbo].[fn_parsehtml]
(
@htmldesc varchar(max)
)
returns varchar(max)
as
begin
declare @first int, @last int,@len int
set @first = CHARINDEX('<',@htmldesc)
set @last = CHARINDEX('>',@htmldesc,CHARINDEX('<',@htmldesc))
set @len = (@last - @first) + 1
while @first > 0 AND @last > 0 AND @len > 0
begin
---Stuff function is used to insert string at given position and delete number of characters specified from original string
set @htmldesc = STUFF(@htmldesc,@first,@len,'')
SET @first = CHARINDEX('<',@htmldesc)
set @last = CHARINDEX('>',@htmldesc,CHARINDEX('<',@htmldesc))
set @len = (@last - @first) + 1
end
return LTRIM(RTRIM(@htmldesc))
end
i have one table as follows
Table name Sample
in table sample record as follows
Courselist
| fees paid by cash> |
| no amount dues> |
Select dbo.fn_parsehtml('Courselist')
but when i execute above query i get output as follows
Courselist (courselist column name only i am getting).
( the courselist column name only i am getting. i want courselist values as fees paid by cash and no amount dues)
what is the mistake in my above code.
Esakki MuthuPosted Dec 12, 2017, 8:06 PM