Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Split a string
- Thread starter VBXL
- Start date
You could use InStr in your own function to get the position of each space in the string, and then chop out the relevant parts using mid$().
However - the easiest way to do this is to use Split() - which returns a string array - each member of the array is a different component of the original string.
e.g.
Dim strComponents() As String
strComponents = Split ("1233566 888888 sasasa 8888888", " "
In this case:
strComponents(0) = "1233566"
strComponents(1) = "888888"
strComponents(2) = "sasasa"
strComponents(3) = "8888888"
which is almost what you asked for!
Quros
However - the easiest way to do this is to use Split() - which returns a string array - each member of the array is a different component of the original string.
e.g.
Dim strComponents() As String
strComponents = Split ("1233566 888888 sasasa 8888888", " "
In this case:
strComponents(0) = "1233566"
strComponents(1) = "888888"
strComponents(2) = "sasasa"
strComponents(3) = "8888888"
which is almost what you asked for!
Quros
- Thread starter
- #3
- Thread starter
- #6
- Status
Similar threads
- Locked
- Question
- Locked
- Question
