{"id":15362,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/dbcs\/"},"modified":"2021-02-25T16:25:26","modified_gmt":"2021-02-25T16:25:26","slug":"dbcs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/dbcs\/","title":{"rendered":"DBCS"},"content":{"rendered":"

Excel ve Google E-Tablolar’da \u00c7ift Bayt Karakter Dizisi Kullan\u0131m\u0131<\/h1>\n

\u00c7al\u0131\u015fma kitaplar\u0131nda veri i\u015fleme s\u0131ras\u0131nda, \u00f6zellikle \u00e7ift bayt karakter setlerini (DBCS) kullanarak metin manip\u00fclasyonu \u00f6nemli bir yer tutar. \u00c7ift bayt karakter setleri, genellikle Asya karakterlerini (\u00f6rne\u011fin Japonca, \u00c7ince) temsil etmek i\u00e7in kullan\u0131l\u0131r. Bu yaz\u0131da, Microsoft Excel ve Google E-Tablolar\u2019da DBCS karakterlerle yap\u0131labilecek i\u015flemler ve bunlar\u0131n nas\u0131l uygulanaca\u011f\u0131na dair bilgiler verilecektir.<\/p>\n

DBCS \u0130\u015flevinin Temelleri<\/h2>\n

\u00c7ift bayt karakter dizisi i\u015flemleri, verileri uygun bi\u00e7ime getirirken veya belli dil gruplar\u0131 i\u00e7in metin i\u015flerken kullan\u0131l\u0131r. Microsoft Excel\u2019de DBCS i\u015flevi, bir karakterin byte say\u0131s\u0131n\u0131 kontrol ederek onun \u00e7ift byte m\u0131 yoksa tek byte m\u0131 oldu\u011funu belirlemeye yarar.<\/p>\n

 S\u00f6zdizimi: DBCS(metin) <\/code> <\/pre>\n
Bu fonksiyon, verilen metin i\u00e7indeki ilk karakterin byte cinsinden uzunlu\u011funu d\u00f6nd\u00fcr\u00fcr. E\u011fer karakter \u00e7ift byte ise 2, tek byte ise 1 de\u011ferini verir.<\/p>\n
Veri Analizi ve Temizleme \u0130\u00e7in Kullan\u0131m \u00d6rnekleri<\/h2>\n
Karakter veri setlerinin analizi ve temizlenmesi s\u0131ras\u0131nda \u00e7ift bayt ve tek bayt karakterlerin ay\u0131rt edilmesi b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. \u00d6zellikle farkl\u0131 dil setlerine sahip verilerin i\u015flenmesi s\u0131ras\u0131nda bu \u00f6nem artar. Burada iki farkl\u0131 senaryo \u00fczerinden Excel ve Google E-Tablolar\u2019da DBCS i\u015flevinin nas\u0131l kullan\u0131labilece\u011fi g\u00f6sterilecektir.<\/p>\n
    \n
  • Senaryo 1: Metin i\u00e7indeki ilk karakterin \u00e7ift bayt olup olmad\u0131\u011f\u0131n\u0131n kontrol\u00fc<\/b>\n
    Bir m\u00fc\u015fteri veritaban\u0131nda, m\u00fc\u015fteri adlar\u0131n\u0131n Asya karakterleri i\u00e7erip i\u00e7ermedi\u011fini kontrol etmek isteyebilirsiniz. E\u011fer m\u00fc\u015fteri ad\u0131n\u0131n ilk karakteri \u00e7ift bayt karakter ise bu, ad\u0131n muhtemelen Asya alfabesine ait oldu\u011funu g\u00f6sterir.<\/p>\n
    =DBCS(A1)<\/code><\/pre>\n
    Bu form\u00fcl, A1 h\u00fccresindeki ad\u0131n ilk karakterinin \u00e7ift bayt olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve sonucu 1 veya 2 olarak d\u00f6nd\u00fcr\u00fcr.<\/p>\n<\/li>\n
  • Senaryo 2: Veritaban\u0131ndaki kay\u0131tlar\u0131n diline g\u00f6re filtreleme<\/b>\n
    Bir veritaban\u0131nda yer alan haber ba\u015fl\u0131klar\u0131 i\u00e7inde hangilerinin \u00f6zel karakterler i\u00e7erdi\u011fini tespit edip, dil bazl\u0131 bir s\u0131n\u0131fland\u0131rma yapmak isteniyor olabilir.<\/p>\n
    =IF(DBCS(B2)=2, \"\u00c7ift Bayt Karakter \u0130\u00e7erir\", \"Standart Karakter \u0130\u00e7erir\")<\/code><\/pre>\n
    Bu form\u00fcl, B2 h\u00fccresindeki metni kontrol eder ve i\u00e7eri\u011fe g\u00f6re d\u00f6n\u00fc\u015f yapar. \u00c7ift bayt karakter i\u00e7eriyorsa belirli i\u015flemleri tetikleyebilir.<\/p>\n<\/li>\n<\/ul>\n
    Yorumlar ve Ek \u00d6neriler<\/h2>\n
    DBCS i\u015flevi, Excel ve Google E-Tablolar\u2019daki metin i\u015fleme fonksiyonlar\u0131 i\u00e7inde \u00f6zel bir yere sahiptir. \u00d6zellikle uluslararas\u0131 veri setleri ile \u00e7al\u0131\u015f\u0131rken, metin baz\u0131nda yap\u0131labilecek analizlerin do\u011frulu\u011fu i\u00e7in b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. \u0130\u015flevin ba\u015far\u0131l\u0131 kullan\u0131m\u0131, veri do\u011frulu\u011funu ve analizlerin etkinli\u011fini art\u0131r\u0131r.<\/p>\n
    Yukar\u0131da verilen \u00f6rnekler, g\u00fcnl\u00fck i\u015f ak\u0131\u015flar\u0131n\u0131zda bu i\u015flevi nas\u0131l kullanabilece\u011finiz konusunda baz\u0131 fikirler sunmu\u015ftur. Ancak, her zaman spesifik ihtiya\u00e7lar\u0131n\u0131za ve \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z veri setlerinin \u00f6zelliklerine g\u00f6re uyarlamalar yapman\u0131z gerekti\u011fini unutmamal\u0131s\u0131n\u0131z.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Karakter dizesindeki tek geni\u015flikli (tek baytl\u0131) \u0130ngilizce harfleri veya katakanay\u0131 \u00e7ift geni\u015flikli (iki baytl\u0131) karakterlerle de\u011fi\u015ftirir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[581],"tags":[],"class_list":["post-15362","post","type-post","status-publish","format-standard","hentry","category-metin"],"acf":[],"yoast_head":"\nExcel'de DBCS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DBCS fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/dbcs\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DBCS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DBCS fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/dbcs\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:25:26+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de DBCS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dbcs\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dbcs\/\",\"name\":\"Excel'de DBCS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:25:26+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DBCS fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/dbcs\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dbcs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dbcs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Metin\",\"item\":\"https:\/\/functiontranslator.com\/tr\/metin\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DBCS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de DBCS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DBCS fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/dbcs\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DBCS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DBCS fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/dbcs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:26+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DBCS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/dbcs\/","url":"https:\/\/functiontranslator.com\/tr\/dbcs\/","name":"Excel'de DBCS Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:25:26+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DBCS fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/dbcs\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dbcs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dbcs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Metin","item":"https:\/\/functiontranslator.com\/tr\/metin\/"},{"@type":"ListItem","position":3,"name":"DBCS"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15362"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15362\/revisions"}],"predecessor-version":[{"id":26630,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15362\/revisions\/26630"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}