dim s as string
s = "ABCDEFGHJKGFDHDFHSHSHH" & char(10) & char(13) & "FKLJKLJGKLGKL" & _
char(10) & char(13) & "FKLJKLJGKLGKGHFDHFDHFDHFL" & _
Char(10) & char(13) & "FKLJKLJGKLGKL" .......'我要得到每个由 char(10) & char(13) 分割开的字符串:
"ABCDEFGHJKGFDHDFHSHSHH"
"FKLJKLJGKLGKL"
"FKLJKLJGKLGKGHFDHFDHFDHFL"
..........
s = "ABCDEFGHJKGFDHDFHSHSHH" & char(10) & char(13) & "FKLJKLJGKLGKL" & _
char(10) & char(13) & "FKLJKLJGKLGKGHFDHFDHFDHFL" & _
Char(10) & char(13) & "FKLJKLJGKLGKL" .......'我要得到每个由 char(10) & char(13) 分割开的字符串:
"ABCDEFGHJKGFDHDFHSHSHH"
"FKLJKLJGKLGKL"
"FKLJKLJGKLGKGHFDHFDHFDHFL"
..........
s = "ABCDEFGHJKGFDHDFHSHSHH" & Chr(10) & Chr(13) & "FKLJKLJGKLGKL" & _
Chr(10) & Chr(13) & "FKLJKLJGKLGKGHFDHFDHFDHFL" & _
Chr(10) & Chr(13) & "FKLJKLJGKLGKL" .......
dim k as string k=char(10) & char(13)
array=split(s,k)
那么array(0)="ABCDEFGHJKGFDHDFHSHSHH"
array(1)="FKLJKLJGKLGKL"
没有试验过哦!
我只是凭感觉
自己试验一下
dim sArray() as string
sArray = split(s, char(10) & char(13))
这样就可以了
dim i as integer
for i = 0 to ubound(sArray)
msgbox sArray(i)
next i
Dim s As String
s = "ABCDEFGHJKGFDHDFHSHSHH" & Chr(10) & Chr(13) & "FKLJKLJGKLGKL" & _
Chr(10) & Chr(13) & "FKLJKLJGKLGKGHFDHFDHFDHFL" & _
Chr(10) & Chr(13) & "FKLJKLJGKLGKL"
Dim outarr() As String
outarr = Split(s, Chr(10) + Chr(13))
Dim i As Long
'测试输出
For i = 0 To UBound(outarr)
Debug.Print outarr(i)
Next
End Sub
不过如果你用vb5的话,用上面的方法不行,只能在循环中用instr结合mid函数取出数据