# SPLIT\_PART

| **Description** | The **`SPLIT_PART()`** function is used to extract a specific part or segment of a text string by splitting it based on a specified delimiter. This function is handy for tasks like separating text data into structured components. |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Syntax**      | SPLIT\_PART(**`text`**, **`delimiter`**, **`part`**)                                                                                                                                                                                  |

1. **`text`**: The input text string that you want to split into parts.
2. **`delimiter`**: The character or substring that is used to separate the text into parts.
3. **`part`**: The part number (integer) you want to extract from the split text.

## Example

### Table

| ID | Text             |
| -- | ---------------- |
| 1  | John,Smith,35    |
| 2  | Apple            |
| 3  | Red, Green, Blue |

### Function

```
SPLIT_PART(`Text`, ',', 2)
```

### Results

| SPLIT\_PART (text) |
| ------------------ |
| Smith              |
|                    |
| Green              |
