Functions/Lists & arrays/array_extract
Lists & arrays Scalar

array_extract()

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

Arguments & returns

4 overloads

array_extract(col0, col1)

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

array_extract(string, index)

Scalar
Overload link stringindex Returns
#02 VARCHARBIGINT VARCHAR

array_extract(struct, entry)

Scalar

Extracts the named entry from the STRUCT.

Overload link structentry Returns
#03 STRUCTVARCHAR ANY

array_extract(struct, index)

Scalar

Extracts the entry from an unnamed STRUCT (tuple) using an index (1-based).

Overload link structindex Returns
#04 STRUCTBIGINT ANY

Example

2 more ↓
array_extract example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

More examples

array_extract example 2
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.
array_extract example 3
SQL
Haybarn WASM 1.5.5-rc3 · 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 ↗