{"id":2308,"date":"2023-07-22T20:19:30","date_gmt":"2023-07-22T20:19:30","guid":{"rendered":"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/"},"modified":"2023-07-22T20:19:30","modified_gmt":"2023-07-22T20:19:30","slug":"google-meninggalkan-permintaan-wildcard","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/","title":{"rendered":"Cara menggunakan wildcard dalam kueri google sheets"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan tanda %<\/strong> sebagai karakter pengganti dalam kueri Google Spreadsheet:<\/span><\/p>\n

Metode 1: Kembalikan sel yang dimulai dengan karakter tertentu<\/strong><\/span><\/p>\n

 =QUERY( A1:A10<\/span> , \" Select A where A like 'hello%'<\/span> \")\n<\/strong><\/pre>\n
 Metode 2: Mengembalikan sel yang diakhiri dengan karakter tertentu<\/strong><\/span><\/p>\n
 =QUERY( A1:A10<\/span> , \" Select A where A like '%hello'<\/span> \")<\/strong><\/pre>\n
 Metode 3: Mengembalikan sel yang berisi karakter tertentu<\/strong><\/span><\/p>\n
 =QUERY( A1:A10<\/span> , \" Select A where A like '%hello%'<\/span> \")<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n
 Metode 1: Kembalikan sel yang dimulai dengan karakter tertentu<\/strong><\/span><\/h3>\n
 Kita bisa menggunakan rumus berikut untuk mengembalikan setiap sel di kolom A yang dimulai dengan “Kami”<\/strong> :<\/span><\/p>\n
 =QUERY( A1:A10<\/span> , \" Select A where A like 'We%'<\/span> \")<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n
\"\"<\/p>\n
 Metode 2: Mengembalikan sel yang diakhiri dengan karakter tertentu<\/strong><\/span><\/h3>\n
 Kita bisa menggunakan rumus berikut untuk mengembalikan setiap sel di kolom A yang diakhiri dengan ‘th’<\/strong> :<\/span><\/p>\n
 =QUERY( A1:A10<\/span> , \" Select A where A like '%th'<\/span> \")<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n
\"\"<\/p>\n
 Metode 3: Mengembalikan sel yang berisi karakter tertentu<\/strong><\/span><\/h3>\n
 Kita bisa menggunakan rumus berikut untuk mengembalikan setiap sel di kolom A yang berisi “atau”<\/strong> di suatu tempat dalam string:<\/span><\/p>\n
 =QUERY( A1:A10<\/span> , \" Select A where A like '%ou%'<\/span> \")<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n
\"\"<\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan kueri umum lainnya di Google Spreadsheet:<\/span><\/p>\n
 Kueri Google Spreadsheet: pilih baris yang berisi string<\/a>
 Kueri Google Spreadsheet: cara menggunakan beberapa kriteria dalam kueri<\/a>
 Kueri Google Spreadsheet: Cara menggunakan referensi sel dalam rumus<\/a>
 Kueri Google Spreadsheet: cara memilih beberapa kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan tanda % sebagai karakter pengganti dalam kueri Google Spreadsheet: Metode 1: Kembalikan sel yang dimulai dengan karakter tertentu =QUERY( A1:A10 , ” Select A where A like ‘hello%’ “) Metode 2: Mengembalikan sel yang diakhiri dengan karakter tertentu =QUERY( A1:A10 , ” Select A where A like ‘%hello’ “) Metode 3: Mengembalikan […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"\nCara menggunakan wildcard dalam kueri Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan wildcard dalam kueri Google Sheets, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan wildcard dalam kueri Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan wildcard dalam kueri Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T20:19:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/requete1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/\",\"url\":\"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/\",\"name\":\"Cara menggunakan wildcard dalam kueri Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T20:19:30+00:00\",\"dateModified\":\"2023-07-22T20:19:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan wildcard dalam kueri Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan wildcard dalam kueri google sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara menggunakan wildcard dalam kueri Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menggunakan wildcard dalam kueri Google Sheets, dengan beberapa contoh.","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:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan wildcard dalam kueri Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan wildcard dalam kueri Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/","og_site_name":"Statorials","article_published_time":"2023-07-22T20:19:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/requete1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/","url":"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/","name":"Cara menggunakan wildcard dalam kueri Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T20:19:30+00:00","dateModified":"2023-07-22T20:19:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan wildcard dalam kueri Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-meninggalkan-permintaan-wildcard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan wildcard dalam kueri google sheets"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2308"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2308"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2308\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}