示例- Dim MyString As String
- Dim X As Integer
- For X = 0 To 10
- MyString = MyString & X & "#:#"
- Next X
- Dim MyValues As Variant
- MyValues = Split(MyString, "#:#", , vbTextCompare)
 
MyString then=";0#:#1 35;:#:2 35;:35;#3 35#::4 35;5 35;6 35难:35;; 7 35安:35安:9 35纳:35纳什:10 35纳:35纳什
分割后,它变为 - MyValues(0) : "0"
- MyValues(1) : "1"
- MyValues(2) : "2"
- MyValues(3) : "3"
- MyValues(4) : "4"
- MyValues(5) : "5"
- MyValues(6) : "6"
- MyValues(7) : "7"
- MyValues(8) : "8"
- MyValues(9) : "9"
- MyValues(10) : "10"
- MyValues(11) : ""
|