Working with text is not always about regular expressions. Although regular expressions look extremely powerful, it’s way easier to make a mistake composing an incorrect search pattern. That’s why it’s super important to be fluent with all non-regex string functions.
In the next couple of lessons we’ll go over all useful string functions (there’re a bunch more but I haven’t used them in the past 10 years, so I bet you won’t need them either).
SPLIT_PART(text_input, delimiter, part_to_select)
I’d say the
SPLIT_PART() function is the one I use...