Nasty String Manipulation

[InsaneProgrammer]

I need help seperating a large string and placing it in 3 variables. The varibles are sClassID, sClassName, and sDate.
The string is in the following format:
sClassID & "--" & sClassName & "-----" & sDate

On the screen it looks like this:
12 Cost Management 1/19/02

How can I seperate it so that I can get:
sClassID = "12"
sClassName = "Cost Management"
sDate = "1/19/02"

Any help would be appreciated.

 

[JohnYingling]

VB6
'sClassID & "--" & sClassName & "-----" & sDate
' 0-1-2-3-4-5-6-7
Dim aryStr() As String
aryStr = Split(strIn,"-&quot
Redim Preserve aryStr(7) ' In case short
sClassID = aryStr(0)
sClassName = aryStr(2)
sDate = aryStr(7)

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript