Description | The |
Syntax | SPLIT_PART( |
Output | text |
Variables
text
: The input text string that you want to split into parts.delimiter
: The character or substring that is used to separate the text into parts.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 |