SplitArgs Method

Returns a Variant that represents an array of the individual items in the specified string separated by the specified character string.

expression.SplitArgs(String, Tokens)

expression    Required. An expression that returns one of the objects in the Applies To list.

String    Required String. The string containing the data.

Tokens    Required String. The character string that separates the items in the String parameter.

Remarks

The SplitArgs method is similar to the Split function in Microsoft Visual Basic; however, the SplitArgs method will not break quote-delimited strings.

Example

The following example splits the specified string into an array of the items in the specified string that are separated by a comma.

    Dim varArray() As Variant

varArray = Application.SplitArgs("this,is a,test", ",")