String

RIGHT

BigQuery

Mengambil sejumlah karakter dari sisi kanan (akhir) string. Shorthand yang lebih mudah dibaca untuk mengambil karakter terakhir.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

RIGHT(value, length)

Parameter

valueSTRINGwajib

String sumber

lengthINT64wajib

Jumlah karakter yang diambil dari kanan

Contoh Penggunaan

Mengambil Suffix

SQL

1 SELECT RIGHT('BigQuery', 5) as result;

Mengambil 5 karakter terakhir.

Hasil

Query

Ekstrak File Extension

SQL

1 SELECT
2   file_name,
3   RIGHT(file_name, 3) as extension
4 FROM `project.dataset.files`
5 LIMIT 3;

Mengambil ekstensi file (3 karakter terakhir).

Hasil

file_name	extension
report.pdf	pdf
data.csv	csv
image.png	png

4 Digit Terakhir untuk Masking

SQL

1 SELECT
2   credit_card_number,
3   CONCAT('****-****-****-', RIGHT(credit_card_number, 4)) as masked_card
4 FROM `project.dataset.payments`
5 LIMIT 3;

Menampilkan hanya 4 digit terakhir kartu kredit.

Hasil

credit_card_number	masked_card
1234567890123456	**--**-3456
9876543210987654	**--**-7654

Mengekstrak Kode dari ID

SQL

1 SELECT
2   transaction_id,
3   RIGHT(transaction_id, 6) as sequence_number
4 FROM `project.dataset.transactions`
5 WHERE RIGHT(transaction_id, 6) LIKE '0001%'
6 LIMIT 3;

Mengambil sequence number dari transaction ID.

Hasil

transaction_id	sequence_number
TRX202401000123	000123
TRX202401000124	000124

Fungsi Terkait

SUBSTRINGSUBSTRLEFT

Kembali ke BigQuery Functions

1	SELECT
2	file_name,
3	RIGHT(file_name, 3) as extension
4	FROM `project.dataset.files`
5	LIMIT 3;

1	SELECT
2	credit_card_number,
3	CONCAT('**--**-', RIGHT(credit_card_number, 4)) as masked_card
4	FROM `project.dataset.payments`
5	LIMIT 3;

1	SELECT
2	transaction_id,
3	RIGHT(transaction_id, 6) as sequence_number
4	FROM `project.dataset.transactions`
5	WHERE RIGHT(transaction_id, 6) LIKE '0001%'
6	LIMIT 3;