Removing text from a string

[alspoll]

Hello all,

i have a string formatted as

a@b@c@d@e

how can i just have d@e or b@e?

TIA,

hope this makes sense.
AL

 

[xwb]

Say you have

rope = "a@b@c@d@e"

how can i just have d@e

backend = right(rope, 3)

or b@e?

Not sure what you're asking for here: is it letters

3, 4, 9
3, 6, 9
3, 8, 9

I'll just assume you mean 3, 6, 9

bits = ""
for i = 3 to len(rope) step 3
   bits = bits & mid(rope, i, 1)
next

 

[taupirho]

Try out the the MID function. It works like this, the first parameter is the string you want to parse. The second is the start postion for "cutting", the third paramter is how many characters you want to "cut". So ...

mystr = MID("a@b@c@d@e",3,3)
Wscript.Echo mystr
mystr = MID("a@b@c@d@e",7,3)
Wscript.Echo mystr

Should return "b@c" and "d@e" respectively

 

[mrmovie]

try the split() function

aArray = Split(strX, "@")
If UBound(aArray) = 5 Then
Wscript.Echo aArray(0) & "@" & aArray(2)
End If