String

REPLACE

BigQuery

Mengganti semua kemunculan substring dengan string baru. Case-sensitive replacement.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

REPLACE(value, old_string, new_string)

valueSTRINGwajib

String sumber

old_stringSTRINGwajib

Substring yang akan diganti

new_stringSTRINGwajib

String pengganti

SQL

1 SELECT REPLACE('Hello World', 'World', 'BigQuery') as result;

Mengganti substring.

Hasil

Hello BigQuery

SQL

1 SELECT
2   REPLACE(REPLACE(REPLACE(phone, '-', ''), ' ', ''), '+', '') as clean_phone
3 FROM `project.dataset.contacts`;

Menghapus formatting dari nomor telepon.

Hasil

clean_phone
6281234567890

SQL

1 SELECT
2   LOWER(REPLACE(REPLACE(title, ' ', '-'), '--', '-')) as slug
3 FROM `project.dataset.articles`;

Membuat URL slug dari title.

1	SELECT
2	REPLACE(REPLACE(REPLACE(phone, '-', ''), ' ', ''), '+', '') as clean_phone
3	FROM `project.dataset.contacts`;

1	SELECT
2	LOWER(REPLACE(REPLACE(title, ' ', '-'), '--', '-')) as slug
3	FROM `project.dataset.articles`;