{"id":4326,"date":"2023-07-11T23:41:01","date_gmt":"2023-07-11T23:41:01","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/"},"modified":"2023-07-11T23:41:01","modified_gmt":"2023-07-11T23:41:01","slug":"vba-menghitung-kemunculan-karakter-dalam-string","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/","title":{"rendered":"Vba: cara menghitung kemunculan karakter dalam sebuah string"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menghitung jumlah kemunculan karakter dalam string menggunakan VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> CountOccurrences()\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n    \n    <span style=\"color: #008000;\">'Specify character to look for<\/span>\n    my_char = \"\/\"\n    \n    <span style=\"color: #008000;\">'Count occurrences in each string in B2:B12 and display results in C2:C12<\/span>\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 12\n        Count = (Len(Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i)) - Len(Replace(Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i), my_char, \"\"))) \/ Len(my_char)\n        Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = Count\n    <span style=\"color: #0000ff;\">Next<\/span> i\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung jumlah kemunculan garis miring ( <strong>\/<\/strong> ) di setiap sel dalam rentang <strong>B2:B12<\/strong> dan menampilkan hasilnya dalam rentang <strong>C2:C12<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menghitung Kemunculan Karakter dalam String Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan nama-nama pemain bola basket yang berbeda dan posisi yang bisa mereka mainkan dalam sebuah permainan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34003 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1.jpg\" alt=\"\" width=\"498\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung jumlah garis miring ( <strong>\/<\/strong> ) pada setiap string pada kolom Posisi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> CountOccurrences()\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n    \n    <span style=\"color: #008000;\">'Specify character to look for<\/span>\n    my_char = \"\/\"\n    \n    <span style=\"color: #008000;\">'Count occurrences in each string in B2:B12 and display results in C2:C12<\/span>\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 12\n        Count = (Len(Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i)) - Len(Replace(Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i), my_char, \"\"))) \/ Len(my_char)\n        Range(\" <span style=\"color: #ff0000;\">C<\/span> \" &amp; i) = Count\n    <span style=\"color: #0000ff;\">Next<\/span> i\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34004 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte2.jpg\" alt=\"\" width=\"518\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Nilai di kolom C menampilkan jumlah kemunculan garis miring pada string yang cocok di kolom B.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">String Guard \/ Forward berisi <strong>1<\/strong> garis miring.<\/span><\/li>\n<li> <span style=\"color: #000000;\">String Penjaga berisi <strong>0<\/strong> garis miring.<\/span><\/li>\n<li> <span style=\"color: #000000;\">String Penjaga berisi <strong>0<\/strong> garis miring.<\/span><\/li>\n<li> <span style=\"color: #000000;\">String Maju\/Tengah berisi <strong>1<\/strong> garis miring.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung kemunculan karakter yang berbeda, cukup ubah karakter variabel <strong>my_char<\/strong> di makro.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/vba-berisi-string\/\" target=\"_blank\" rel=\"noopener\">VBA: cara memeriksa apakah suatu string berisi string lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><br \/> VBA: Cara menulis fungsi COUNTIF dan COUNTIFS<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menghitung jumlah kemunculan karakter dalam string menggunakan VBA: Sub CountOccurrences() Dim i As Integer &#8216;Specify character to look for my_char = &#8220;\/&#8221; &#8216;Count occurrences in each string in B2:B12 and display results in C2:C12 For i = 2 To 12 Count = (Len(Range(&#8221; B &#8221; &amp; i)) &#8211; [&hellip;]<\/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":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara menghitung kemunculan karakter dalam string - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kemunculan karakter tertentu dalam sebuah string menggunakan VBA, dengan sebuah 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\/vba-menghitung-kemunculan-karakter-dalam-string\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menghitung kemunculan karakter dalam string - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kemunculan karakter tertentu dalam sebuah string menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T23:41:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1.jpg\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/\",\"name\":\"VBA: Cara menghitung kemunculan karakter dalam string - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T23:41:01+00:00\",\"dateModified\":\"2023-07-11T23:41:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah kemunculan karakter tertentu dalam sebuah string menggunakan VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menghitung kemunculan karakter dalam sebuah string\"}]},{\"@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":"VBA: Cara menghitung kemunculan karakter dalam string - Statorials","description":"Tutorial ini menjelaskan cara menghitung jumlah kemunculan karakter tertentu dalam sebuah string menggunakan VBA, dengan sebuah 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\/vba-menghitung-kemunculan-karakter-dalam-string\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menghitung kemunculan karakter dalam string - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung jumlah kemunculan karakter tertentu dalam sebuah string menggunakan VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/","og_site_name":"Statorials","article_published_time":"2023-07-11T23:41:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/compte1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/","url":"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/","name":"VBA: Cara menghitung kemunculan karakter dalam string - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T23:41:01+00:00","dateModified":"2023-07-11T23:41:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah kemunculan karakter tertentu dalam sebuah string menggunakan VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menghitung kemunculan karakter dalam sebuah string"}]},{"@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\/4326"}],"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=4326"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4326\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}