{"id":2755,"date":"2023-07-20T20:46:38","date_gmt":"2023-07-20T20:46:38","guid":{"rendered":"https:\/\/statorials.org\/id\/substring-mongodb\/"},"modified":"2023-07-20T20:46:38","modified_gmt":"2023-07-20T20:46:38","slug":"substring-mongodb","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/substring-mongodb\/","title":{"rendered":"Mongodb: cara menggunakan fungsi $susbtr"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan fungsi $substr<\/strong> di MongoDB untuk mengekstrak substring dari sebuah string.<\/span><\/p>\n

Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n

 db.myCollection.aggregate([\n  { $project<\/span> : {substring: { $substr<\/span> : [ \" $fullstring<\/span> \", 0, 4 ] }}}\n])<\/strong><\/pre>\n
 Contoh khusus ini mengekstrak keempat karakter dari bidang berlabel “fullString” mulai dari posisi 0.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaks ini dalam praktik dengan penjualan<\/span> koleksi dengan dokumen berikut:<\/span><\/p>\n
 db.sales.insertOne({yearMonth: 201702, amount: 40<\/span> })\ndb.sales.insertOne({yearMonth: 201802, amount: 32<\/span> })\ndb.sales.insertOne({yearMonth: 201806, amount: 19<\/span> })\ndb.sales.insertOne({yearMonth: 201910, amount: 29<\/span> })\ndb.sales.insertOne({yearMonth: 201907, amount: 35<\/span> })<\/strong><\/pre>\n
 Contoh: Cara menggunakan fungsi $susbtr di MongoDB<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan kode berikut untuk mengekstrak empat karakter pertama dari kolom “tahunBulan” dan menampilkannya di kolom baru bernama “tahun”:<\/span><\/p>\n
 db.sales.aggregate([\n  { $project<\/span> : {year: { $substr<\/span> : [ \" $yearMonth<\/span> \", 0, 4 ] }}}\n])\n<\/strong><\/pre>\n
 Kode ini menghasilkan hasil sebagai berikut:<\/span><\/p>\n
 { _id: ObjectId(\"620145544cb04b772fd7a929\"), year: '2017' }\n{ _id: ObjectId(\"620145544cb04b772fd7a92a\"), year: '2018' }\n{ _id: ObjectId(\"620145544cb04b772fd7a92b\"), year: '2018' }\n{ _id: ObjectId(\"620145544cb04b772fd7a92c\"), year: '2019' }\n{ _id: ObjectId(\"620145544cb04b772fd7a92d\"), year: '2019' }<\/strong><\/pre>\n
 Perhatikan bahwa empat karakter pertama dari kolom “bulanTahun” setiap dokumen ditampilkan di kolom baru berlabel “tahun”.<\/span><\/p>\n
 Penting untuk diperhatikan bahwa kode ini hanya menampilkan<\/em> substring.<\/span><\/p>\n
 Untuk benar-benar menambahkan field baru ke koleksi yang berisi substring ini, kita perlu menggunakan fungsi $merge<\/strong> sebagai berikut:<\/span><\/p>\n
 db.sales.aggregate([\n  { $project<\/span> : {year: { $substr<\/span> : [ \" $yearMonth<\/span> \", 0, 4 ] }}},\n  { $merge<\/span> : \"sales\" }\n])<\/strong><\/pre>\n
 Seperti inilah tampilan koleksi yang diperbarui sekarang:<\/span><\/p>\n
 { _id: ObjectId(\"620145544cb04b772fd7a929\"),\n  yearMonth: 201702,\n  amount: 40,\n  year: '2017' }\n{ _id: ObjectId(\"620145544cb04b772fd7a92a\"),\n  yearMonth: 201802,\n  amount: 32,\n  year: '2018' }\n{ _id: ObjectId(\"620145544cb04b772fd7a92b\"),\n  yearMonth: 201806,\n  amount: 19,\n  year: '2018' }\n{ _id: ObjectId(\"620145544cb04b772fd7a92c\"),\n  yearMonth: 201910,\n  amount: 29,\n  year: '2019' }\n{ _id: ObjectId(\"620145544cb04b772fd7a92d\"),\n  yearMonth: 201907,\n  amount: 35,\n  year: '2019' }<\/strong><\/pre>\n
 Perhatikan bahwa kolom baru berjudul “tahun” telah ditambahkan ke setiap dokumen dalam koleksi dan menampilkan empat karakter pertama dari kolom “tahunBulan”.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi $substr<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di MongoDB:<\/span><\/p>\n
 MongoDB: Cara memeriksa apakah bidang berisi string<\/a>
 MongoDB: Cara menggabungkan string dari dua bidang<\/a>
 MongoDB: Cara mengganti string<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan fungsi $substr di MongoDB untuk mengekstrak substring dari sebuah string. Fungsi ini menggunakan sintaks dasar berikut: db.myCollection.aggregate([ { $project : {substring: { $substr : [ ” $fullstring “, 0, 4 ] }}} ]) Contoh khusus ini mengekstrak keempat karakter dari bidang berlabel “fullString” mulai dari posisi 0. Contoh berikut menunjukkan cara menggunakan […]<\/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":"\nMongoDB: Cara menggunakan fungsi $susbtr - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi substr di MongoDB untuk mengekstrak substring dari string, beserta contohnya.\" \/>\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\/substring-mongodb\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MongoDB: Cara menggunakan fungsi $susbtr - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi substr di MongoDB untuk mengekstrak substring dari string, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/substring-mongodb\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T20:46:38+00:00\" \/>\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\/substring-mongodb\/\",\"url\":\"https:\/\/statorials.org\/id\/substring-mongodb\/\",\"name\":\"MongoDB: Cara menggunakan fungsi $susbtr - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T20:46:38+00:00\",\"dateModified\":\"2023-07-20T20:46:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi substr di MongoDB untuk mengekstrak substring dari string, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/substring-mongodb\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/substring-mongodb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/substring-mongodb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mongodb: cara menggunakan fungsi $susbtr\"}]},{\"@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":"MongoDB: Cara menggunakan fungsi $susbtr - Statologi","description":"Tutorial ini menjelaskan cara menggunakan fungsi substr di MongoDB untuk mengekstrak substring dari string, beserta contohnya.","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\/substring-mongodb\/","og_locale":"id_ID","og_type":"article","og_title":"MongoDB: Cara menggunakan fungsi $susbtr - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi substr di MongoDB untuk mengekstrak substring dari string, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/substring-mongodb\/","og_site_name":"Statorials","article_published_time":"2023-07-20T20:46:38+00:00","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\/substring-mongodb\/","url":"https:\/\/statorials.org\/id\/substring-mongodb\/","name":"MongoDB: Cara menggunakan fungsi $susbtr - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T20:46:38+00:00","dateModified":"2023-07-20T20:46:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi substr di MongoDB untuk mengekstrak substring dari string, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/substring-mongodb\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/substring-mongodb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/substring-mongodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Mongodb: cara menggunakan fungsi $susbtr"}]},{"@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\/2755"}],"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=2755"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2755\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}