String

REGEXP_INSTR

BigQuery

Mengembalikan posisi (1-based) dari substring yang cocok dengan regular expression. Return 0 jika tidak ada match.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

REGEXP_INSTR(source_value, regexp [, position [, occurrence [, occurrence_position]]])

source_valueSTRINGwajib

String yang akan dicari

regexpSTRINGwajib

Regular expression pattern

positionINT64opsional

Posisi awal pencarian

Default: 1

occurrenceINT64opsional

Occurrence ke-n yang dicari

Default: 1

occurrence_positionINT64opsional

0=awal match, 1=akhir match

Default: 0

SQL

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

Temukan posisi angka pertama.

Hasil

text	number_pos
abc123def	4
no numbers	0

SQL

1 SELECT
2   REGEXP_INSTR('abc123def456', r'[0-9]+', 1, 2) as second_num_pos;

Posisi occurrence kedua dari pattern.

Hasil

SQL

1 SELECT
2   REGEXP_INSTR('abc123def', r'[0-9]+', 1, 1, 1) as after_number;

Posisi setelah match berakhir.

Hasil

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

1	SELECT
2	REGEXP_INSTR('abc123def456', r'[0-9]+', 1, 2) as second_num_pos;

1	SELECT
2	REGEXP_INSTR('abc123def', r'[0-9]+', 1, 1, 1) as after_number;