String

REGEXP_COUNT

Snowflake

Menghitung jumlah kemunculan pattern regex dalam string.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

REGEXP_COUNT(string, pattern [, position [, parameters]])

stringVARCHARwajib

String sumber

patternVARCHARwajib

Regular expression pattern

positionINTEGERopsional

Posisi awal pencarian (default: 1)

SQL

1 SELECT REGEXP_COUNT('The quick brown fox jumps', '\\w+') as word_count;

Menghitung jumlah kata dalam kalimat.

Hasil

SQL

1 SELECT REGEXP_COUNT(content, '[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}') as email_count
2 FROM documents;

Menghitung jumlah email dalam dokumen.

SQL

1 SELECT REGEXP_COUNT(tweet, '#[a-zA-Z0-9_]+') as hashtag_count
2 FROM tweets;

Menghitung jumlah hashtag dalam tweet.

1	SELECT REGEXP_COUNT(content, '[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}') as email_count
2	FROM documents;

1	SELECT REGEXP_COUNT(tweet, '#[a-zA-Z0-9_]+') as hashtag_count
2	FROM tweets;