Delete characters between "|"

[cosfreelance]

Hi all,

I am trying to delete characters between a start and stop character. I have currently set this character to "|"

how do I delete the characters in between?

any help will be appreciated. thanks in advance

 

[PHV]

And what have YOU tried so far ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cosfreelance]

PHV,

This is what i have so far ! I have change the "|" to "<" and ">" below


str = "<Field1> Test"

mypos = instr(str,"<")
for x=mypos+1 to len(str)
if mid(str,x,1)=">" Then
str = Mid(str, x, len(str))
str = Replace(str,">","")
MsgBox str
end If
Next

this works if the str is as above

however if thr str is

str = "<Field1> Test <approved>"

then the <approved> is not removed.

 

[PHV]

What about this ?
myStr = "<Field1> Test <approved>"
i = InStr(myStr,"<"): j = InStr(myStr,">")
While i > 0 And j > i
myStr = Left(myStr,i-1) & Mid(myStr,j+1)
i = InStr(myStr,"<"): j=InStr(myStr,">")
Wend
MsgBox myStr

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tsuji]

[tt]set rx=new regexp
with rx
.global=true
.pattern="<[^>]*?>"
end with

str="<Field1> Test <approved>"
t=rx.replace(str,"")
wscript.echo str & vbcrlf & t[/tt]

 

[monksnake]

I like tsuji's method witht the regexp.

I'm going to clean up the pattern just a bit though. Since you want to remove the characters between '<' and '>', if there are no characters between <>, there is nothing to remove, so we really don't need to match that in the regexp.

This is what I have for a pattern:

.pattern="<[^>]+>"

<.

 

[cosfreelance]

Thanks everyone,

Your help has enabled me to achieve what I wanted.

Regards