array_extract()

Extracts a single character from a string using a (1-based) index.

Reference: DuckDB 2.0.0

Arguments & returns

4 overloads

array_extract(list, index)

Scalar
Overload link listindex Returns
#01 T[]BIGINT T

array_extract(string, index)

Scalar
Overload link stringindex Returns
#02 VARCHARBIGINT VARCHAR

array_extract(struct, entry)

Scalar
Overload link structentry Returns
#03 STRUCTVARCHAR ANY

array_extract(tuple, index)

Scalar
Overload link tupleindex Returns
#04 TUPLEBIGINT ANY

Example

array_extract example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.

In other engines

BigQueryregexp_extract()

SELECT REGEXP_EXTRACT(abc, 'pattern(group)', 2, 3) FROM table
In DuckDB
SELECT ARRAY_EXTRACT(REGEXP_EXTRACT_ALL(NULLIF(SUBSTRING(abc, 2), ''), 'pattern(group)', 1), 3) FROM "table"

SQLGlot example โ†—

Snowflakeregexp_substr()

REGEXP_SUBSTR(subject, pattern, 1, 2)
In DuckDB
ARRAY_EXTRACT(REGEXP_EXTRACT_ALL(subject, pattern), 2)

SQLGlot example โ†—