REGEXP_EXTRACT_ALL

DuckDB

regexp_extract_all(string, regex, group, options)

• string: VARCHAR
• regex: VARCHAR
• group: VARCHAR[]
• options: VARCHAR

Example

SELECT regexp_extract_all('Peter: 33, Paul:14', '(\w+):\s*(\d+)', 2);