當前位置:成語大全網 - 新華字典 - vba split函數的使用方法?

vba split函數的使用方法?

vba split函數的使用方法如下:

原型:

Function Split(

ByVal Expression As String,

Optional ByVal Delimiter As String = " ",

Optional ByVal Limit As Integer = -1,

Optional ByVal Compare As CompareMethod = CompareMethod.Binary

) As String()

入參說明:

Expression 是要處理分割的字符串

Delimiter 是要指定分隔符比如" "

Limit 可選參數,指定最大分割子串

Compare 可選

舉例說明:

Dim TestString As String = "apple pear banana "

Dim TestArray() As String = Split(TestString)

' TestArray holds {"apple", "", "", "", "pear", "banana", "", ""}

Dim LastNonEmpty As Integer = -1

For i As Integer = 0 To TestArray.Length - 1

If TestArray(i) <> "" Then

LastNonEmpty += 1

TestArray(LastNonEmpty) = TestArray(i)

End If

Next

ReDim Preserve TestArray(LastNonEmpty)

' TestArray now holds {"apple", "pear", "banana"}