Replace Does Not Seem To Work

Mar 18, 2008

My function keeps going into a loop. The fucntion removes html tags. It works great with everything except with this one 4,363 character string. I'm not quite sure what the problem is, please advise.

Thank you.
I may have a bunch of extra declarations that dont make sense to you but they were part of my debugging...
Also don't let all the code distract you, the long string is just the value of the html tag I'm trying to replace with nothing.
Also there are a bunch of replaces before the while loop but the magic happens in the while loop.
i've assiged to @temp the only part that my html code that replace could not replace.

Every other tag I could see the function removing, it would find the beginning of the tag, end of tag, substring it and replace it. but this one it would find it substsring it and was unable to replace it and comes back with "String or binary data would be truncated." and then it loops infinetly because it keeps finding the tags it could not remove.

please help. thank you.

also.. I'm not sure if you call can see what I see but when I review this a bunch of emoticons show up? not sure why I did not pu them there, just relate them to their correspnonding code, colon uppercase P, :-# colon dash pound, colon uppercase S.

declare @temp nvarchar(max), @input nvarchar(max), @count1 int, @count2 int, @wtf nvarchar(30), @blankString nvarchar(max), @beginBlanks int, @countBlanks int, @removeString nvarchar(max), @openTagPos int, @closeTagPos int, @emailString nvarchar(max)

set @temp = 'hi'

set @input = @temp

set @emailString = @input

set @emailString = replace(@emailString,'''','''''')

set @openTagPos = charindex('<', @emailString)

set @closeTagPos = charindex('>', @emailString)

set @emailString = replace(@emailString,'> <','><')

set @emailString = replace(@emailString,' ','')

set @emailString = replace(@emailString,'v:* {behavior:url(#default#VML);}','')

set @emailString = replace(@emailString,'o:* {behavior:url(#default#VML);}','')

set @emailString = replace(@emailString,'w:* {behavior:url(#default#VML);}','')

set @emailString = replace(@emailString,'.shape {behavior:url(#default#VML);}','')

set @emailString = replace(@emailString,'st1:*{behavior:url(#default#ieooui) }','')

set @emailString = replace(@emailString,'’','''')

set @emailString = replace(@emailString,'“','"')

set @emailString = replace(@emailString,'”','"')

set @emailString = replace(@emailString,'…','...')

set @emailString = replace(@emailString,'–','-')

set @emailString = replace(@emailString,'t./','')

While (@openTagPos + @closeTagPos) <> 0

BEGIN

SET @removeString = substring(@emailstring, @openTagPos, @closeTagPos - @openTagPos + 1)

set @emailString = replace(@emailString,@removeString,'')
--This select is just to see what is happening

select len(@emailString) sizeOfString,@removeString stringToRemove, @opentagpos beginOfTag, @closetagpos endOfTag, @emailstring theString

set @openTagPos = charindex('<', @emailstring)

set @closeTagPos = charindex('>', @emailstring)

END

select @emailString

View 8 Replies

Replace Does Not Seem To Work

Replace Parameter Doesnt Work

REPLACE Function Doesn't Work With Null-bytes

SQL Replace '-' By ''

Replace?

Replace

Replace '

Replace Roa

Using Replace

How To Replace Having

Using 'IN' To Replace 'EXCEPT'

Find And Replace

Replace &<br&> Tag In CRLF

Replace, The ' Character, And Yea...

How To Do REPLACE In SQL Queries

Replace Function In SQL?

REPLACE Used In Query

Find And Replace.

Using Replace Function

SQL To Replace String

SQL Replace Apostrophe

SQL To Replace String

Using Like Function With Replace

REPLACE Function

SQL To Replace String

SQL Regex Replace How-To?

Create Or Replace

Replace Data Using Sql

Replace Query? Possible?

REPLACE Name If Code Like

Replace Funtion

How To Replace Data From One Col With Another Col

Replace Command