regexp_replace(string, pattern)


Query

presto:default> SELECT regexp_replace('1a 2b 3c 6f', '\d+ [abc] ') as expression;

Result

 expression 
------------ 
    6f 

Replace the instance of the string matched for the expression with the pattern (d + [abc]).

apache_presto_sql_functions.htm
Advertisements