Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Contoh penggunaan
REGEXP_CONTAINS(Page, 'home')
Sintaks
REGEXP_CONTAINS( X, regular_expression )
Parameter
X - kolom atau ekspresi yang akan dievaluasi.
regular_expression - ekspresi reguler.
Hasil
Fungsi REGEXP_CONTAINS menampilkan nilai jenis data Boolean.
Contoh
Example formula
Input
Output
REGEXP_CONTAINS(Field, 'A')
ABC123
true
REGEXP_CONTAINS(Field, 'A.\*')
ABC123
true
REGEXP_CONTAINS(Field, 'AC')
ABC123
false
Catatan
REGEXP_CONTAINS berbeda dari fungsi REGEXP_MATCH yang serupa, yang hanya akan mencocokkan seluruh nilai secara default. Dengan demikian, REGEXP_CONTAINS(field,"pattern") secara fungsional setara dengan REGEXP_MATCH(field,".*pattern.*").
Perhatikan bahwa pola yang berisi karakter escape seperti \ mungkin memerlukan escape tambahan di Looker Studio, yang dapat dihindari menggunakan literal string mentah.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-07-31 UTC."],[],[],null,["# REGEXP_CONTAINS\n\nSample usage\n------------\n\n`REGEXP_CONTAINS(Page, 'home')`\n\nSyntax\n------\n\n`REGEXP_CONTAINS( `\u003cvar translate=\"no\"\u003eX\u003c/var\u003e`, `\u003cvar translate=\"no\"\u003eregular_expression\u003c/var\u003e` )`\n\n### Parameters\n\n- *\u003cvar translate=\"no\"\u003eX\u003c/var\u003e* - a field or expression to evaluate.\n\n- *\u003cvar translate=\"no\"\u003eregular_expression\u003c/var\u003e* - a regular expression.\n\n### Returns\n\nThe `REGEXP_CONTAINS` function returns **Boolean** data type values.\n\n### Examples\n\n### Notes\n\n`REGEXP_CONTAINS` differs from the similar [`REGEXP_MATCH`](/looker/docs/studio/regexpmatch) function, which will only match the *entire* value by default. Thus, `REGEXP_CONTAINS(field,\"pattern\")` is functionally equivalent to `REGEXP_MATCH(field,\".*pattern.*\")`.\n\nLooker Studio uses the RE2 expression syntax. For more details, see [Regular Expressions in Looker Studio](/looker/docs/studio/regular-expressions-in-looker-studio).\n\nNote that patterns containing escape characters such as `\\` may require additional escaping in Looker Studio, which can be avoided with the use of [raw string literals](/looker/docs/studio/literals).\n\nRelated resources\n-----------------\n\n- [Calculated fields](/looker/docs/studio/about-calculated-fields)\n- [Looker Studio function list](/looker/docs/studio/function-list)"]]
