String

SUBSTRING

Q: Apa saja parameter fungsi SUBSTRING?

Fungsi ini memiliki 2 parameter wajib dan 1 parameter opsional. Parameter yang digunakan: value (STRING, wajib): The string to extract from; position (INT64, wajib): The starting position (1-indexed). Negative values count from the end of the string; length (INT64, opsional): The number of characters to extract.

BigQuery

Extracts a portion of characters from a string. Identical to SUBSTR, available for standard SQL compatibility.

Tipe hasil: STRINGDiperbarui: 13 Jun 2026

Syntax

SQL

SUBSTRING(value, position [, length])

Parameter

valueSTRINGwajib

The string to extract from

positionINT64wajib

The starting position (1-indexed). Negative values count from the end of the string

lengthINT64opsional

The number of characters to extract

Contoh Penggunaan

Basic SUBSTRING

SQL

1 SELECT SUBSTRING('BigQuery SQL', 1, 8) as result;

Extracts the first 8 characters.

Hasil

BigQuery

SUBSTRING for Email Domain

SQL

1 SELECT
2   email,
3   SUBSTRING(email, STRPOS(email, '@') + 1) as domain
4 FROM `project.dataset.users`
5 LIMIT 3;

Extracts the domain portion from an email address.

Hasil

email	domain
john@gmail.com	gmail.com
jane@company.co.id	company.co.id

Combined with LENGTH

SQL

1 SELECT
2   file_name,
3   SUBSTRING(file_name, 1, LENGTH(file_name) - 4) as name_without_ext
4 FROM `project.dataset.files`
5 WHERE file_name LIKE '%.csv';

Removes the .csv extension from a file name.

Hasil

file_name	name_without_ext
sales_2024.csv	sales_2024
report.csv	report

Pertanyaan Umum tentang SUBSTRING

Apa itu fungsi SUBSTRING di BigQuery?

Extracts a portion of characters from a string. Identical to SUBSTR, available for standard SQL compatibility. Di BigQuery, fungsi SUBSTRING termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan SUBSTRING di BigQuery?

Gunakan sintaks berikut: SUBSTRING(value, position [, length]). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi SUBSTRING?

Fungsi SUBSTRING mengembalikan nilai bertipe STRING. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda - selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Fungsi Terkait

SUBSTRLEFTRIGHT

Ngulik Langsung

Sudah paham SUBSTRING? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	email,
3	SUBSTRING(email, STRPOS(email, '@') + 1) as domain
4	FROM `project.dataset.users`
5	LIMIT 3;

1	SELECT
2	file_name,
3	SUBSTRING(file_name, 1, LENGTH(file_name) - 4) as name_without_ext
4	FROM `project.dataset.files`
5	WHERE file_name LIKE '%.csv';