> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: STRSPLIT

> Split a string into a tuple of substrings using a specified delimiter character. Use STRSPLIT for parsing delimited text data in ETL pipelines.

## Description

Splits a string into a tuple around matches of a delimiter.

## Syntax

`STRSPLIT(string[, delimiter_regex[, limit]])`

## Arguments

*string* - string expression

*delimiter\_regex* - regular expression string delimiter. Optional with default '\s'.

*limit* - integer indicating the number of times the regular expression pattern is applied. Optional with default 0.

## Examples

`STRSPLIT('Mary:had:a little:lamb',':',3)` returns a tuple (Mary,had,a little:lamb)

`STRSPLIT('Mary:had:a little:lamb',':',3).$0` returns a string `Mary`

`STRSPLIT('Mary:had:a little:lamb',':',3).$1` returns a string `had`

## Return value datatype

Tuple

## Impact of null value

If input is null, returns null.