{"id":1806,"date":"2023-11-03T15:54:58","date_gmt":"2023-11-03T15:54:58","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/"},"modified":"2023-12-06T06:20:46","modified_gmt":"2023-12-06T06:20:46","slug":"teks-tersebut-berisi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/","title":{"rendered":"Power query: jika teks berisi"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3390068016\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Power Query, Anda bisa menggunakan fungsi Text.Contains yang bisa Anda gunakan untuk menguji apakah substring ada dalam string atau tidak. fungsi ini, kita juga dapat menggunakan pernyataan IF untuk menguji substring.<\/p><p> Pada contoh di bawah ini, kita memiliki daftar kata benda dengan akhiran maskulin dan feminin. Dan kita perlu memeriksa kata benda mana yang memiliki akhiran feminin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88996\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"teks-berisi-fungsi-dalam-kuasa-kueri\" width=\"348\" height=\"294\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Menggunakan TEXT.CONTAINS di Power Query<\/h2><ol><li> Buka tab Data &gt; Dapatkan Data &gt; Dari Sumber Lain &gt; Dari Tabel\/Rentang. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-dapatkan-data-dari-tabel-rentang-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-obtenir-des-donnees-de-la-plage-de-table-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"get-data-from-table-range\" width=\"495\" height=\"380\"><\/li><li> Sekarang, masuk ke Tambahkan Kolom &gt; Kolom Khusus di Editor Kueri yang Kuat. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-kolom-kustom-dalam-kueri-kuasa-editor\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-colonnes-personnalisees-dans-lediteur-de-requete-puissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"custom-column-in-power-query-editor\" width=\"492\" height=\"153\"><\/li><li> Dari sana, di kotak dialog rumus khusus, masukkan (=Teks.Berisi([Nama], \u00bbMs.&#8221;)). <br><img loading=\"lazy\" decoding=\"async\" title=\"4-dalam-kotak-dialog-masukkan-teks-berisi-fungsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-dans-la-boite-de-dialogue-entrez-le-texte-contient-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"in-dialog-box-enter-text-contains-function\" width=\"635\" height=\"200\"><\/li><li> Pada akhirnya, klik OK untuk menambahkan kolom.<\/li><\/ol><p> Bila di klik OK maka akan masuk kolom baru dengan isi TRUE dan FALSE. BENAR jika Teks berisi \u201cMs.\u201d dan SALAH untuk sisanya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89000\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-nouvelle-colonne-ajoutee-avec-vrai-ou-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom-baru-ditambahkan-dengan-benar-atau-salah\" width=\"417\" height=\"309\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Bagaimana cara kerja fitur ini?<\/h2><p> Dalam fungsi tersebut Anda memiliki dua argumen untuk didefinisikan. Pada argumen pertama (Teks), kolom berisi teks utama yang ingin Anda periksa kondisinya.<\/p><p> Dan di argumen kedua (substring) Anda perlu menentukan substring yang ingin Anda periksa di string utama argumen pertama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89001\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-comment-le-texte-contient-la-fonction-fonctionne.png\" sizes=\"auto, \" srcset=\"\" alt=\"cara kerja-teks-berisi-fungsi\" width=\"364\" height=\"96\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gunakan IF untuk memeriksa konten teks<\/h2><p> Anda juga dapat menggunakan pernyataan IF untuk memeriksa apakah beberapa teks berisi teks lain. Dengan menggunakan IF Anda dapat menggunakan hasil yang bermakna, bukan TRUE dan FALSE. Jadi, di editor kueri lanjutan, Anda perlu membuka kolom Tambah dan klik pada kolom bersyarat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89002\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-si-pour-verifier-le-texte-contient.png\" sizes=\"auto, \" srcset=\"\" alt=\"jika-periksa-teks-berisi\" width=\"618\" height=\"315\"><\/figure><\/div><p> Ketika Anda mengklik kolom kondisional, kotak dialog muncul untuk membuat pernyataan IF. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89003\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-colonne-conditionnelle-a-creer-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom-bersyarat-untuk-membuat-jika\" width=\"784\" height=\"306\"><\/figure><\/div><p> Di sini Anda harus:<\/p><ol type=\"1\"><li> Masukkan nama kolom.<\/li><li> Pilih nama kolom untuk memeriksa kondisinya.<\/li><li> Pilih operator \u201cberisi\u201d.<\/li><li> Nilai untuk diperiksa, \u201cMs.\u201d.<\/li><li> Output yang didapat jika kondisinya TRUE, \u201cWanita\u201d.<\/li><li> Dan output untuk mendapatkan kondisinya adalah FALSE, \u201cMale\u201d.<\/li><li> Terakhir, klik OK untuk masuk ke kolom.<\/li><\/ol><p> Saat Anda mengklik OK, Anda akan mendapatkan kolom baru berisi \u201cWanita\u201d di mana Teks berisi \u201cMs\u201d. benar, dan sebaliknya untuk \u201cManusia\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-89004\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-nouvelle-colonne-apres-linstruction-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom-baru-setelah-jika-pernyataan\" width=\"433\" height=\"321\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/le-texte-contient-une-requete-avancee.xlsx\" rel=\"nofollow\">Unduh<\/a><\/p><\/div><div class=\"gb-container gb-container-9e2850fe gb-container-mt\"> <a class=\"gb-button gb-button-71636faa gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/permintaan-kekuatan\/\">Power Query di Excel (Tutorial)<\/a><h2 class=\"gb-headline gb-headline-c566b2ed gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-b15ed1bf gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6e9de105\"><div class=\"gb-container gb-container-6e9de105\"><ul><li> Gabungkan [Gabungkan] Beberapa FILE Excel menjadi SATU BUKU CATATAN<\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pencarianv-2\/\">Lakukan VLOOKUP di Power Query di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/data-yang-tidak-diputar\/\">Hapus pivot data di Excel menggunakan Power Query<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rantai\/\">Power Query: menggabungkan nilai (teks dan angka)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbedaan-tanggal\/\">Power Query: Perbedaan tanggal<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-4eaecde3\"><div class=\"gb-container gb-container-4eaecde3\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1806","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Teks berisi Power Query (periksa apakah ada string)<\/title>\n<meta name=\"description\" content=\"Berikut cara memeriksa apakah substring ada dalam string atau tidak menggunakan Power Query di Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Teks berisi Power Query (periksa apakah ada string)\" \/>\n<meta property=\"og:description\" content=\"Berikut cara memeriksa apakah substring ada dalam string atau tidak menggunakan Power Query di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/\",\"name\":\"Teks berisi Power Query (periksa apakah ada string)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png\",\"datePublished\":\"2023-11-03T15:54:58+00:00\",\"dateModified\":\"2023-12-06T06:20:46+00:00\",\"description\":\"Berikut cara memeriksa apakah substring ada dalam string atau tidak menggunakan Power Query di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power query: jika teks berisi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Teks berisi Power Query (periksa apakah ada string)","description":"Berikut cara memeriksa apakah substring ada dalam string atau tidak menggunakan Power Query di Excel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/","og_locale":"id_ID","og_type":"article","og_title":"Teks berisi Power Query (periksa apakah ada string)","og_description":"Berikut cara memeriksa apakah substring ada dalam string atau tidak menggunakan Power Query di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/","url":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/","name":"Teks berisi Power Query (periksa apakah ada string)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png","datePublished":"2023-11-03T15:54:58+00:00","dateModified":"2023-12-06T06:20:46+00:00","description":"Berikut cara memeriksa apakah substring ada dalam string atau tidak menggunakan Power Query di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-texte-contient-une-fonction-dans-la-requete-de-puissance.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/teks-tersebut-berisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Power query: jika teks berisi"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1806"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1806\/revisions"}],"predecessor-version":[{"id":2939,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1806\/revisions\/2939"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}