dim TheStr as string dim TempStr() as stringTheStr="a,b,c,d" '被分隔的字符串private sub ToSplit() Tempstr=Split(TheStr,",") '将分隔出来的每一段放入字符串数组里。。 End Sub
dim i ,j dim tempstr i=instr(1,string,",") tempstr=right(string,i-1) i=tempstr(j,string,",") tempstr2=mid(,,,) ,,,,,, 再想想,画画瓢吧
to hhdsq:我也是这么做的,呵呵 谢谢各位了。 舍不得分呀,:)
Private Sub Command1_Click() Dim tstr As String tstr = ",a,b,c,d," Dim tastr() As String tastr = Split(tstr, ",") Dim i As Integer For i = 1 To UBound(tastr) - 1 MsgBox tastr(i) Next i End Sub
用left(),取出后将它赋给一个变量。
dim TempStr() as stringTheStr="a,b,c,d" '被分隔的字符串private sub ToSplit()
Tempstr=Split(TheStr,",") '将分隔出来的每一段放入字符串数组里。。
End Sub
dim tempstr
i=instr(1,string,",")
tempstr=right(string,i-1)
i=tempstr(j,string,",")
tempstr2=mid(,,,)
,,,,,,
再想想,画画瓢吧
谢谢各位了。
舍不得分呀,:)
Dim tstr As String
tstr = ",a,b,c,d,"
Dim tastr() As String
tastr = Split(tstr, ",")
Dim i As Integer
For i = 1 To UBound(tastr) - 1
MsgBox tastr(i)
Next i
End Sub