VB Code:
Private Sub Form_Load()
Dim Fred() As String
Dim X As Integer
Fred = vb5Split("this" & vbCrLf & "is" & vbCrLf & "only" & vbCrLf & "a" & vbCrLf & "test", vbCrLf)
For X = 0 To UBound(Fred)
MsgBox Fred(X)
Next X
End Sub
Public Function vb5Split(ByVal sText As String, sDelim As String) As String()
Dim sTemp() As String
Dim X As Integer
X = -1
sText = sText & sDelim
Do While InStr(1, sText, sDelim) > 0
X = X + 1
ReDim Preserve sTemp(X)
sTemp(X) = Left(sText, InStr(1, sText, sDelim) - 1)
sText = Mid(sText, Len(sTemp(X)) + Len(sDelim) + 1)
Loop
vb5Split = sTemp
End Function
There you have it a split function. The Form_Load Junk is an example of how to use it. Have fun.