### Split

Basic and Crystal syntax.

##### Overloads

- Split (inputString)
- Split (inputString, delimiter)
- Split (inputString, delimiter, count)
- Split (inputString, delimiter, count, compare)

##### Arguments

- inputString is a String expression containing substrings and delimiters.
- delimiter is an optional String character used to identify substring limits. If omitted, the space character (" ") is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire inputString string is returned.
- count is an optional number value of substrings to be returned. The value -1 indicates that all substrings are returned. If omitted, -1 is assumed.
- compare is an optional Number indicating the kind of comparison to use when evaluating the delimiter string:
  - Performs a comparison that is case-sensitive
  - Performs a comparison that is case-insensitive

    If omitted, a case-sensitive comparison is performed.

##### Returns

Array of String values.

##### Action

Split takes a String that contains a number of substrings, breaks it up into a specified number of substrings and returns an array containing the substrings.

##### Examples

The following examples are applicable to both Basic and Crystal syntax:

`Split ("Chocolate Strawberry Pineapple")`

Returns an array that contains 3 elements, "Chocolate", "Strawberry" and "Pineapple".

`Split ("Chocolate//Strawberry//Pineapple", "//")`

Returns an array that contains 3 elements, "Chocolate", "Strawberry" and "Pineapple".

`Split ("Chocolate//Strawberry//Pineapple", "//", 2)`

Returns an array that contains 2 elements, "Chocolate" and "Strawberry//Pineapple". The last element in the array is a concatenation of the 2nd substring and the remaining substring.

`Split ("Chocolate and Strawberry and Pineapple", " And ", -1, 0)`

Returns an array that contains 1 element, "Chocolate and Strawberry and Pineapple". The delimiter " And " cannot be matched.

`Split ("Chocolate and Strawberry and Pineapple", " And ", -1, 1)`

Returns an array that contains 3 elements, "Chocolate", "Strawberry" and "Pineapple". The delimiter " And " is matched with " and " regardless of the case.

##### Comments

- This function is designed to work like the Visual Basic function of the same name.
- If count, c, is less than the total number of substrings in inputString, then at most c substrings will be returned as elements in the resultant array. The last element in the array being a concatenation of the c-th substring and all the remaining substrings.

###### Related topics

Join

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com