---
schema_version: "1"
id: 18232357b74c0c300602796c921b5b00d44d62ab3fb63b2cdb9f765181a3d3b4
title: SPLIT
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/string-func/split.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/split.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 213476cf7dde9db3a1ca84587a30504d7bcdec2257ac5856f132839d44eee168
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `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](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/split-part.md)
- [Array Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/array.md)
- [String Types](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/string.md)