String Manipulation

I have a string in which I have the fromat like

abc.xyz.bcd

How can I grab xyz from the sting or bcd from the string
monalisaAsked:
Who is Participating?
 
dgb001Commented:
Dim oldstring as string
Dim newstring as string
Dim X as byte

let oldstring = "abc.xyz.bcd"
let X=INSTR(oldstring,"bcd")
let newstring=mid(oldstring,X,3)

Just do a similar thing for the other ones. There are of course many variations on how to do this, and also with less code, but you should probably be able to follow this code with no problem.




abc.xyz.bcd

0
 
clifABBCommented:
You duplicated the question again.  :)

You should delete this one, I've answered the other.
0
 
monalisaAuthor Commented:
Thank you very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.