split_part(string,delimiter,index)


Query

presto:default> select split_part('apache presto’,'p',2); 

Result

 _col0 
------- 
 ache
apache_presto_sql_functions.htm
Advertisements