# Split
Split

`split` splits a string into an array of substrings, based on a delimiter that you choose, and returns the item specified by the position.

You can only add `split` to a calculated field during data preparation, not to an analysis. This function is not supported in direct queries to Microsoft SQL Server.

## Syntax


```
split(expression, delimiter , position)
```

## Arguments


 *expression*   
The expression must be a string. It can be the name of a field that uses the string data type, a literal value like **'12 Main Street;1402 35th Ave;1818 Elm Ct;11 Janes Lane'**, or a call to another function that outputs a string.

 *delimiter*   
The character that delimits where the string is broken into substrings. For example, `split('one|two|three', '|', 2)` becomes the following.  

```
one
two
three
```
If you choose `position = 2`, `split` returns `'two'`.

 *position*   
(Required) The position of the item to return from the array. The position of the first item in the array is 1.

## Return type


String array

## Example


The following example splits a string into an array, using the semicolon character (;) as the delimiter, and returns the third element of the array.

```
split('123 Test St;1402 35th Ave;1818 Elm Ct;11 Janes Lane', ';', 3)
```

The following item is returned.

```
1818 Elm Ct
```

This function skips items containing null values or empty strings.