• Home
 · 
• Miscellaneous
 · 
• How to take the particular string from a sentence?

How to take the particular string from a sentence?

How to take the particular string from a sentence?

API Declarations


String I have to clip is 4254 using 'instrrev'method
copy the following code and paste it in V.B 6 it will work.




Rate How to take the particular string from a sentence?

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

a = InStrRev("02:245:4254-253", ":", Len("02:245:4254-253"))
b = InStr(1, "02:245:4254-253", "-", vbTextCompare)
MsgBox Mid("02:245:4254-253", (a + 1), ((b - a) - 1))
End Sub