String

REGEXP_EXTRACT_ALL

BigQuery

Mengekstrak semua substring yang cocok dengan regular expression dan mengembalikannya sebagai array.

Tipe hasil: ARRAY<STRING>Diperbarui: 7 Jan 2026

Syntax

SQL

REGEXP_EXTRACT_ALL(value, regexp)

valueSTRINGwajib

String sumber

regexpSTRINGwajib

Regular expression pattern

SQL

1 SELECT
2   text,
3   REGEXP_EXTRACT_ALL(text, r'[0-9]+') as numbers
4 FROM `project.dataset.logs`;

Ekstrak semua angka dari text.

Hasil

text	numbers
Order #123 Item #456	["123", "456"]
No numbers here	[]

SQL

1 SELECT
2   tweet,
3   REGEXP_EXTRACT_ALL(tweet, r'#(\w+)') as hashtags
4 FROM `project.dataset.tweets`;

Ekstrak semua hashtags tanpa simbol #.

Hasil

tweet	hashtags
#BigQuery is #awesome!	["BigQuery", "awesome"]

SQL

1 SELECT
2   id,
3   hashtag
4 FROM `project.dataset.tweets`,
5 UNNEST(REGEXP_EXTRACT_ALL(tweet, r'#(\w+)')) as hashtag;

Expand array hasil ekstraksi ke rows.

1	SELECT
2	text,
3	REGEXP_EXTRACT_ALL(text, r'[0-9]+') as numbers
4	FROM `project.dataset.logs`;

1	SELECT
2	tweet,
3	REGEXP_EXTRACT_ALL(tweet, r'#(\w+)') as hashtags
4	FROM `project.dataset.tweets`;

1	SELECT
2	id,
3	hashtag
4	FROM `project.dataset.tweets`,
5	UNNEST(REGEXP_EXTRACT_ALL(tweet, r'#(\w+)')) as hashtag;