String

SPLIT

BigQuery

Splits a string into an array based on a delimiter. Very useful for parsing CSV-style data.

Tipe hasil: ARRAY<STRING>Diperbarui: 13 Jun 2026

Syntax

SQL

SPLIT(value [, delimiter])

Parameter

valueSTRINGwajib

The string to split

delimiterSTRINGopsional

The separator character (default: comma ',')

Contoh Penggunaan

Split by Comma

SQL

1 SELECT SPLIT('a,b,c') as result;

Splits a string on commas.

Hasil

['a', 'b', 'c']

Parse CSV Column

SQL

1 SELECT
2   id,
3   SPLIT(tags, ',') as tag_array,
4   ARRAY_LENGTH(SPLIT(tags, ',')) as tag_count
5 FROM `project.dataset.posts`;

Parses a comma-separated tags column.

Hasil

id	tag_array	tag_count
1	["tech", "ai", "ml"]	3
2	["business", "startup"]	2

Access Split Element

SQL

1 SELECT
2   email,
3   SPLIT(email, '@')[OFFSET(0)] as username,
4   SPLIT(email, '@')[OFFSET(1)] as domain
5 FROM `project.dataset.users`;

Accesses individual elements from the split result.

Hasil

email	username	domain
john@gmail.com	john	gmail.com

Split Path

SQL

1 SELECT
2   file_path,
3   ARRAY_REVERSE(SPLIT(file_path, '/'))[OFFSET(0)] as file_name
4 FROM `project.dataset.files`;

Extracts the filename from a file path.

Hasil

file_path	file_name
/home/user/docs/file.txt	file.txt

Pertanyaan Umum tentang SPLIT

Apa itu fungsi SPLIT di BigQuery?

Splits a string into an array based on a delimiter. Very useful for parsing CSV-style data. Di BigQuery, fungsi SPLIT termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan SPLIT di BigQuery?

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

Apa nilai yang dikembalikan oleh fungsi SPLIT?

Fungsi SPLIT mengembalikan nilai bertipe ARRAY<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.

Apa saja parameter fungsi SPLIT?

Fungsi ini memiliki 1 parameter wajib dan 1 parameter opsional. Parameter yang digunakan: value (STRING, wajib): The string to split; delimiter (STRING, opsional): The separator character (default: comma ',').

Ngulik Langsung

Sudah paham SPLIT? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	id,
3	SPLIT(tags, ',') as tag_array,
4	ARRAY_LENGTH(SPLIT(tags, ',')) as tag_count
5	FROM `project.dataset.posts`;

1	SELECT
2	email,
3	SPLIT(email, '@')[OFFSET(0)] as username,
4	SPLIT(email, '@')[OFFSET(1)] as domain
5	FROM `project.dataset.users`;

1	SELECT
2	file_path,
3	ARRAY_REVERSE(SPLIT(file_path, '/'))[OFFSET(0)] as file_name
4	FROM `project.dataset.files`;