how do I find all characters that follow a specific character in .

D

Dave Tyler

how do I find all characters that follow a specific character in a string?
Can I use Mid someway?
 
D

Dirk Goldgar

Dave Tyler said:
how do I find all characters that follow a specific character in a
string? Can I use Mid someway?

Example:

Dim strSource As String
Dim strTail As String

strSource = "abcdefghijklm#nopqrstuvwxyz"

' Get all characters following the "#" (not including it).
strTail = Mid(strSource, InStr(strSource, "#") + 1)
 
Top