SPLIT_PART

Extracts a specific part of a text string using a delimiter

Updated over a week ago

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)

Output

text

Variables

  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

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

ID

Text

SPLIT_PART

1

John,Smith,35

Smith

2

Apple

3

Red, Green, Blue

Green

Did this answer your question?