split_part(string text, delimiter text, field int)

Let us now check the split_part(string,delimiter,index) function with the following query.

Query

default> select split_part('tutorialspoint','t', 3) as split;

Result

The above query will generate the following result.

split 
------------------------------- 
orialspoin 

The split_part() method splits a string ‘tutorialspoint’ from the delimiter ’t’ with the index position 3. The result is “orialspoin”.

Kickstart Your Career

Get certified by completing the course

Get Started