Private Sub Command1_Click() Dim i As Integer Dim MyString() As String MyString() = Split("1-22-333-4444-55555", "-", -1, 1) For i = 0 To UBound(MyString) Debug.Print MyString(i) Next End Sub
dim str1 as string ,str2 as string str1=split("X-Y","-")(0) str2=split("X-Y","-")(1) 表达形式上的简单 实际上执行两次split,效率不一定高
Private Sub Command1_Click() Dim strA, strLL As String Dim str As Integer strLL = "Then-You" strA = Split(strLL, "-") MsgBox x = strA(0) MsgBox y = strA(1) End Sub
dim str1,str2 as string 这样定义str1不是string来的,做编程的要注意细节 应该dim str1 as string,str2 as string同时同意7楼的见解
arr = split(X-Y,"-")
str1=arr[0]
str2=arr[1]
xx=split(s,"-")
str1=xx(0)
str2=xx(1)
感觉不是最最简单的!!
如果X或Y中本身也有减号符号存在呢?
Dim i As Integer
Dim MyString() As String
MyString() = Split("1-22-333-4444-55555", "-", -1, 1)
For i = 0 To UBound(MyString)
Debug.Print MyString(i)
Next
End Sub
这个正确阿, 把split的参数都看看。
"abc-123-999-kkk-222"
楼主手工分一下X和Y,能分出来吗?
小可以为用Split就很好了
要不
先自定义一个字符传判断函数,在用MID()
str2=split("X-Y","-")(1)
表达形式上的简单
实际上执行两次split,效率不一定高
Dim strA, strLL As String
Dim str As Integer
strLL = "Then-You"
strA = Split(strLL, "-")
MsgBox x = strA(0)
MsgBox y = strA(1)
End Sub
这样定义str1不是string来的,做编程的要注意细节
应该dim str1 as string,str2 as string同时同意7楼的见解