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

XML Verileri Nas\u0131l Filtrelenir: XMLF\u0130LTRELE Fonksiyonu Kullan\u0131m Rehberi<\/h1>\n

Verilerin filtrelenmesi ve y\u00f6netilmesi, veri analizi ve raporlama i\u00e7in kritik bir \u00f6neme sahiptir. XML dosyalar\u0131, web ba\u011flant\u0131l\u0131 uygulamalarda s\u0131k\u00e7a kullan\u0131lan veri yap\u0131lar\u0131ndand\u0131r. Excel’de XML verilerini etkin bir \u015fekilde filtrelemek ve i\u015flemek i\u00e7in XMLF\u0130LTRELE (\u0130ngilizce ad\u0131yla FILTERXML) fonksiyonu kullan\u0131l\u0131r. Bu yaz\u0131da, bu fonksiyonun s\u00f6zdizimi detaylar\u0131 ile birlikte, pratik uygulamalar\u0131na yer verece\u011fiz.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n

XMLF\u0130LTRELE<\/strong> fonksiyonu iki parametre al\u0131r:<\/p>\n

 XMLF\u0130LTRELE(xml, xpath) <\/code> <\/pre>\n
    \n
  • xml:<\/strong> \u0130\u015flenecek XML verisini i\u00e7erir. Veri, do\u011frudan XML metni olarak veya bir h\u00fccreye referans vererek dahil edilebilir.<\/li>\n
  • xpath:<\/strong> Filtreleme ve veri \u00e7ekme i\u015flemi i\u00e7in kullan\u0131lacak XPath ifadesidir. XPath, XML belgesinde d\u00fc\u011f\u00fcmleri tan\u0131mlamak i\u00e7in kullan\u0131lan bir dil olup, belirtilen kriterlere g\u00f6re veriyi filtrelemeyi sa\u011flar.<\/li>\n<\/ul>\n
    Ger\u00e7ek D\u00fcnya Uygulamalar\u0131<\/h2>\n
    XMLF\u0130LTRELE<\/strong> fonksiyonun etkili kullan\u0131m alanlar\u0131ndan iki tanesini \u00f6rneklerle inceleyelim:<\/p>\n
    1. Hava Durumu Verilerinin Filtrelenmesi<\/h3>\n
    Web’den al\u0131nan hava durumu verilerini i\u00e7eren bir XML dosyas\u0131ndan belirli bilgileri \u00e7ekme:<\/p>\n
     <?xml version=\"1.0\"?> <weather> <city name=\"Istanbul\"> <temperature value=\"20\" unit=\"celsius\"\/> <\/city> <city name=\"Ankara\"> <temperature value=\"18\" unit=\"celsius\"\/> <\/city> <\/weather> <\/code> <\/pre>\n
    Yukar\u0131daki XML verisinden sadece Ankara’n\u0131n s\u0131cakl\u0131k de\u011ferini \u00e7ekmek i\u00e7in kullan\u0131lacak XPath ve XMLF\u0130LTRELE kombinasyonu \u015fu \u015fekildedir:<\/p>\n
     =XMLF\u0130LTRELE(A1, \"\/\/city[@name='Ankara']\/temperature\/@value\") <\/code> <\/pre>\n
    Burada, A1 h\u00fccresi XML verilerini i\u00e7erir ve XPath ifadesi ile Ankara’ya ait s\u0131cakl\u0131k de\u011feri \u00e7ekilmektedir.<\/p>\n
    2. M\u00fc\u015fteri Bilgilerinin \u00c7ekilmesi<\/h3>\n
    \u015eirketinize ait m\u00fc\u015fteri bilgilerinin yer ald\u0131\u011f\u0131 bir XML dosyas\u0131ndan belirli m\u00fc\u015fteri detaylar\u0131n\u0131 almak:<\/p>\n
     <?xml version=\"1.0\"?> <customers> <customer id=\"1\"> <name>Emre Aslan<\/name> <email>emreaslan@example.com<\/email> <\/customer> <customer id=\"2\"> <name>Derya Kaya<\/name> <email>deryakaya@example.com<\/email> <\/customer> <\/customers> <\/code> <\/pre>\n
    XML’den id’si 2 olan m\u00fc\u015fterinin ismini \u00e7ekmek i\u00e7in:<\/p>\n
     =XMLF\u0130LTRELE(A1, \"\/\/customer[@id='2']\/name\") <\/code> <\/pre>\n
    A1 h\u00fccresinde yer alan XML verisinden id’si 2 olan m\u00fc\u015fterinin ismi \u00e7ekilecektir.<\/p>\n
    Yorumlar<\/h2>\n
    XMLF\u0130LTRELE fonksiyonu, XML verileri i\u00e7inden belirli bilgilerin etkili bir \u015fekilde \u00e7ekilmesini sa\u011flar. Bu, \u00f6zellikle web hizmetlerinden gelen b\u00fcy\u00fck ve karma\u015f\u0131k veri setlerini y\u00f6netmek, raporlamak ve analiz etmek i\u00e7in olduk\u00e7a faydal\u0131d\u0131r. Fonksiyonun do\u011fru kullan\u0131m\u0131 i\u00e7in, XPath ifadelerindeki do\u011frulu\u011fun \u00f6nemli oldu\u011funu unutmamak gerekir.<\/p>\n
    Umar\u0131z bu rehber, XML verilerinizle \u00e7al\u0131\u015fmalar\u0131n\u0131zda size yard\u0131mc\u0131 olur ve i\u015f ak\u0131\u015flar\u0131n\u0131z\u0131 kolayla\u015ft\u0131r\u0131r. XML ve XPath konusunda daha fazla bilgi ve pratik yaparak bu fonksiyondan maksimum fayday\u0131 sa\u011flayabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Belirtilen XPath’i kullanarak XML i\u00e7eri\u011finden belirli verileri d\u00f6nd\u00fcr\u00fcr<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[590],"tags":[],"class_list":["post-15409","post","type-post","status-publish","format-standard","hentry","category-web-13"],"acf":[],"yoast_head":"\nExcel'de FILTERXML (XMLF\u0130LTRELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da FILTERXML (XMLF\u0130LTRELE) 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\/filterxml\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de FILTERXML (XMLF\u0130LTRELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da FILTERXML (XMLF\u0130LTRELE) 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\/filterxml\/\" \/>\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:26:58+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 FILTERXML (XMLF\u0130LTRELE) 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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/filterxml\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/filterxml\/\",\"name\":\"Excel'de FILTERXML (XMLF\u0130LTRELE) 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:26:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da FILTERXML (XMLF\u0130LTRELE) 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\/filterxml\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/filterxml\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/filterxml\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Web\",\"item\":\"https:\/\/functiontranslator.com\/tr\/web-13\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"XMLF\u0130LTRELE\"}]},{\"@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 FILTERXML (XMLF\u0130LTRELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da FILTERXML (XMLF\u0130LTRELE) 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\/filterxml\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de FILTERXML (XMLF\u0130LTRELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da FILTERXML (XMLF\u0130LTRELE) 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\/filterxml\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:26:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de FILTERXML (XMLF\u0130LTRELE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/filterxml\/","url":"https:\/\/functiontranslator.com\/tr\/filterxml\/","name":"Excel'de FILTERXML (XMLF\u0130LTRELE) 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:26:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da FILTERXML (XMLF\u0130LTRELE) 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\/filterxml\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/filterxml\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/filterxml\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Web","item":"https:\/\/functiontranslator.com\/tr\/web-13\/"},{"@type":"ListItem","position":3,"name":"XMLF\u0130LTRELE"}]},{"@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\/15409","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=15409"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15409\/revisions"}],"predecessor-version":[{"id":26677,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15409\/revisions\/26677"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}