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

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/string/split-part",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for SPLIT_PART function

# SPLIT_PART

Splits `<string>` at occurrences of `<delimiter>` and returns the `<index>`'th field, with 1 being the first index.
If `<index>` is negative, returns the `abs(<index>)`'th-from-last field.
If `<delimiter>` is empty, `<string>` is returned at `<index>` 1.
If `abs(<index>)` is larger than the number of fields, returns an empty string.
The function raises an error for `<index>` 0.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SPLIT_PART(<string>, <delimiter>, <index>)
```

## Parameters

| Parameter     | Description                                                           | Supported input types |
| :------------ | :-------------------------------------------------------------------- | :-------------------- |
| `<string>`    | The string to be split.                                               | `TEXT`                |
| `<delimiter>` | The character used to split the string.                               | `TEXT`                |
| `<index>`     | The index position of the substring to return within the split parts. | `INTEGER`             |

## Return Type

`TEXT`

## Examples

**Example**

The following code example uses the delimiter `#` to split the string `'hello#world'`, and returns the first segment:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	SPLIT_PART('hello#world','#',1) AS res;
```

**Returns**

`'hello'`

**Example**

The following code example uses the delimiter `|` to split the string `'this|is|my|test'`, and returns the second to last segment:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	SPLIT_PART('this|is|my|test', '|', -2) AS res;
```

**Returns**

`'my'`

**Example**

The following code example uses an empty delimiter `''` to split the string `'hello world'`, and returns the first segment:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	SPLIT_PART('hello world', '', 1) AS res;
```

**Returns**

`hello world`

In the previous code example, `SPLIT_PART` sees the empty delimiter and interprets the entire string as the first and only part of the string and returns 'hello world'.

**Example**

The following code example uses an empty delimiter `''` to split the string `'hello world'`, and returns the first segment:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	SPLIT_PART('hello world', '', 7) AS res;
```

**Returns**

`''`

In the previous code example, `SPLIT_PART` sees the empty delimiter and interprets the entire string as the first and only part of the string. Because there is no seventh part to return, `SPLIT_PART` returns an empty string.