Private Sub Form_Load()
Dim a(2)
a(0) = "1 3467 c-basic"
a(1) = "2 3563 vb-vc"
a(2) = "3 3742 sql-sybase"
For i = 0 To 2
MsgBox Join(Split(Split(a(i), " ")(2), "-"), " ,")
Next
End Sub
Private Sub Command1_Click()
On Error Resume Next
Dim arr As Variant
Dim mbyte() As Byte
Dim mlen As Long
Dim filename As String
filename = "c:\tt.txt"
mlen = FileLen(filename)
ReDim mbyte(mlen - 1)
Open filename For Binary As #1
Get #1, , mbyte
Close #1
Dim s As String
s = StrConv(mbyte, vbUnicode)
'如果数据保存在字串中,则从此开始
arr = Split(s, vbCrLf)
Dim i As Long, j As Long, m As Long
Dim langleft() As String, langright() As String
Dim k As Long
Dim temps As String, arrtemp As Variant
k = 0
For i = 0 To UBound(arr)
If Len(arr(i)) > 0 Then
ReDim Preserve langleft(k)
ReDim Preserve langright(k)
m = Len(arr(i))
j = InStrRev(arr(i), " ")
temps = Right(arr(i), m - j)
arrtemp = Split(temps, "-")
langleft(k) = arrtemp(0)
langright(k) = arrtemp(1)
Debug.Print langleft(k)
Debug.Print langright(k)
k = k + 1
End If
Next
End Sub