"大,小,多," 这个字符串用split按逗号拆分后是一个数组,包含4个成员(条目)分别是:"大"、"小"、"多"和 "" ,我们可以通过trim函数来删除开头和结尾空字符。由下图可知,4个条目最后变为3个。代码如下
Sub a()
Dim a, b, c
a = "大,小,多,"
b = Split(a, ",")
c = Trim(Join(b))
d = Split(c)
End Sub
"大,小,多," 这个字符串用split按逗号拆分后是一个数组,包含4个成员(条目)分别是:"大"、"小"、"多"和 "" ,我们可以通过trim函数来删除开头和结尾空字符。由下图可知,4个条目最后变为3个。代码如下
Sub a()
Dim a, b, c
a = "大,小,多,"
b = Split(a, ",")
c = Trim(Join(b))
d = Split(c)
End Sub