當前位置:成語大全網 - 新華字典 - excel VB split 中文本和數字的區別

excel VB split 中文本和數字的區別

split(split(s,

",")(i),

",")(0)輸出是s字符串通過","分割後的第i個數組內的字符再次使用","分割後的第0個數組內的字符

比如s=",1,2,3,4,5,"

此時allnum1(linenum1)=5,linenum1=1

for

i

=

1

to

allnum1(linenum1)

numbernum1(linenum1,

i)

=

split(split(s,

",")(i),

",")(0)

next

i

split過程如下

split(s,

",")(0)=""

split(s,

",")(1)="1"

split(s,

",")(2)="2"

split(s,

",")(3)="3"

split(s,

",")(4)="4"

split(s,

",")(5)="5"

split(s,

",")(6)=""

外面再有壹級split

是將上面分割的字符串再次通過

","分割並取分割後的第壹個字符