# Split

{% hint style="info" %}
The **`Split()`** function splits a <mark style="color:blue;">text</mark> into an array of text values.

On an array (like resulting from this split) you can access a specific item by its position in the array, using the `(i)` (1-based) positioning indicator.

This function is NOT SQL compatible. For more information about SQL compatibility, see our [documentation](https://docs.wem.io/platform/~/changes/y5gAfiyi2fILzrLzUUHj/wemreference/sql-compatibility).
{% endhint %}

{% hint style="warning" %}
Note: The `separator`is case sensitive!
{% endhint %}

{% hint style="success" %}
Returns an <mark style="color:green;">array</mark> of text values split at each point where the separator occurs in the given text.
{% endhint %}

### Syntax

<details>

<summary><code>Split(</code><mark style="color:blue;"><code>text</code></mark><code>, </code><mark style="color:blue;"><code>separator</code></mark><code>)</code></summary>

`Split("Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",")`\
\&#xNAN;*=> ("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec")*

`Split("Jan,Feb,`**`Mar`**`,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec", ",")`**`(3)`**\
\&#xNAN;*=> "Mar"*

</details>

### Parameters

<table><thead><tr><th width="150">Name</th><th width="150">Type</th><th width="150" align="center">Required</th><th width="248.15953250810662">Description</th><th data-hidden>Required?</th></tr></thead><tbody><tr><td><mark style="color:blue;"><code>text</code></mark></td><td>text</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>The text to split.</td><td>yes</td></tr><tr><td><mark style="color:blue;"><code>separator</code></mark> </td><td>text</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>Specifies the character(s) to use for separating the text.</td><td></td></tr></tbody></table>