regexp_extract_all(string, pattern)


Query

presto:default> SELECT regexp_extract_all('1a 2b 3c 6f', '\d+') as regularexp; 

Result

 regularexp 
-------------- 
 [1, 2, 3, 6] 

Here, the query returns the string matched by the regular expression for the pattern specified only in digits.

apache_presto_sql_functions.htm
Advertisements