# `SPLIT`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Splits a string into an array based on a delimiter.

## Syntax

```sql
split(<string>, <delimiter>)
```

## Arguments

### Required

- `<string>`: The text string to split.
- `<delimiter>`: The delimiter string to split on.

## Returns

Returns an array of text values that contains the split segments.

## Considerations

- Given a NULL delimiter, the function returns NULL.
- An empty delimiter splits the string into individual characters.
- The function supports delimiters longer than one character.

## Examples

### Split on Delimiter

Split a string on a comma delimiter.

```sql
SELECT split('apple,banana,cherry', ',') AS result;
```

Returns `array['apple', 'banana', 'cherry']`.

### Split with Multi-Character Delimiter

Split using a multi-character delimiter.

```sql
SELECT split('one::two::three', '::') AS result;
```

Returns `array['one', 'two', 'three']`.

### Split into Individual Characters

Use an empty delimiter to split into characters.

```sql
SELECT split('hello', '') AS result;
```

Returns `array['h', 'e', 'l', 'l', 'o']`.

### NULL Delimiter

Demonstrate NULL handling with delimiter.

```sql
SELECT split('hello', NULL) AS result;
```

Returns `NULL`.

## Related Documentation

- [SPLIT_PART](/docs/data/data-cloud-query-guide/references/dc-sql-reference/split-part.md)
- [Array Type](/docs/data/data-cloud-query-guide/references/dc-sql-reference/array.md)
- [String Types](/docs/data/data-cloud-query-guide/references/dc-sql-reference/string.md)