String

SPLIT_PART

Snowflake

Memecah string berdasarkan delimiter dan mengembalikan bagian tertentu.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

SPLIT_PART(string, delimiter, part_number)

Parameter

stringVARCHARwajib

String yang akan dipecah

delimiterVARCHARwajib

Karakter atau string pemisah

part_numberINTEGERwajib

Nomor bagian yang diambil (dimulai dari 1). Negatif menghitung dari akhir.

Contoh Penggunaan

Memecah Email

SQL

1 SELECT
2   email,
3   SPLIT_PART(email, '@', 1) as username,
4   SPLIT_PART(email, '@', 2) as domain
5 FROM users;

Memisahkan username dan domain dari alamat email.

Hasil

EMAIL	USERNAME	DOMAIN
john@example.com	john	example.com
jane@company.co.id	jane	company.co.id

Parsing Path

SQL

1 SELECT
2   file_path,
3   SPLIT_PART(file_path, '/', -1) as filename
4 FROM files;

Mengambil nama file (bagian terakhir) dari path menggunakan index negatif.

Hasil

FILE_PATH	FILENAME
/data/raw/file.csv	file.csv
/output/report.pdf	report.pdf

Parsing CSV dalam Kolom

SQL

1 SELECT
2   id,
3   tags,
4   SPLIT_PART(tags, ',', 1) as first_tag,
5   SPLIT_PART(tags, ',', 2) as second_tag,
6   SPLIT_PART(tags, ',', 3) as third_tag
7 FROM products;

Memecah kolom tags yang berisi nilai CSV menjadi kolom terpisah.

Hasil

ID	TAGS	FIRST_TAG	SECOND_TAG	THIRD_TAG
1	electronics,sale,new	electronics	sale	new
2	clothing,premium	clothing	premium

Fungsi Terkait

SUBSTRINGLEFTRIGHTSPLITSTRTOKSTRTOK_TO_ARRAY

Kembali ke Snowflake Functions

1	SELECT
2	email,
3	SPLIT_PART(email, '@', 1) as username,
4	SPLIT_PART(email, '@', 2) as domain
5	FROM users;

1	SELECT
2	file_path,
3	SPLIT_PART(file_path, '/', -1) as filename
4	FROM files;

1	SELECT
2	id,
3	tags,
4	SPLIT_PART(tags, ',', 1) as first_tag,
5	SPLIT_PART(tags, ',', 2) as second_tag,
6	SPLIT_PART(tags, ',', 3) as third_tag
7	FROM products;