String

SPLIT

BigQuery

Memecah string menjadi array berdasarkan delimiter. Sangat berguna untuk parsing CSV-style data.

Tipe hasil: ARRAY<STRING>Diperbarui: 7 Jan 2026

Syntax

SQL

SPLIT(value [, delimiter])

valueSTRINGwajib

String yang akan dipecah

delimiterSTRINGopsional

Pemisah (default: koma ',')

SQL

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

Memecah string dengan koma.

Hasil

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

SQL

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

Parse comma-separated tags.

Hasil

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

SQL

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

Mengakses elemen hasil split.

Hasil

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

SQL

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

Mengekstrak filename dari path.

Hasil

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

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`;