{"id":29332,"date":"2025-09-11T12:10:38","date_gmt":"2025-09-11T09:10:38","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/"},"modified":"2025-09-11T12:10:38","modified_gmt":"2025-09-11T09:10:38","slug":"powershell-import-csv-and-extract-specific-columns-ceviri","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/","title":{"rendered":"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)"},"content":{"rendered":"

# PowerShell: CSV’den Belirli S\u00fctunlar\u0131 \u00c7\u0131karma<\/p>\n

G\u00fcn\u00fcm\u00fczde veri i\u015fleme, her \u00f6l\u00e7ekteki i\u015fletme i\u00e7in vazge\u00e7ilmez bir ihtiya\u00e7t\u0131r. Veri genellikle CSV (Comma Separated Values) dosyalar\u0131 \u015feklinde saklan\u0131r ve bu dosyalar\u0131n i\u00e7indeki belirli bilgilere h\u0131zl\u0131ca ula\u015fmak, analiz etmek veya ba\u015fka sistemlere aktarmak \u00e7o\u011fu zaman gereklidir. PowerShell, bu i\u015flemi kolayla\u015ft\u0131ran g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bu makalede, PowerShell kullanarak CSV dosyalar\u0131ndan belirli s\u00fctunlar\u0131 nas\u0131l \u00e7\u0131karaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m \u00f6\u011frenece\u011fiz. Ba\u015flang\u0131\u00e7 seviyesinden ileri seviyeye kadar her a\u015famada pratik \u00f6rneklerle ve performans optimizasyon teknikleriyle, PowerShell’in g\u00fcc\u00fcn\u00fc ke\u015ffedece\u011fiz.<\/p>\n

\u00d6\u011frenme Yol Haritas\u0131:<\/strong><\/p>\n

* Yeni Ba\u015flayan:<\/strong> Temel komutlar ve basit \u00f6rnekler ile CSV dosyalar\u0131n\u0131n nas\u0131l okunup belirli s\u00fctunlar\u0131n nas\u0131l se\u00e7ilece\u011fi.
\n* Orta Seviye:<\/strong> Ger\u00e7ek hayat senaryolar\u0131, daha karma\u015f\u0131k filtreleme ve verinin nas\u0131l i\u015flenece\u011fi \u00fczerine \u00f6rnekler ve optimizasyon ipu\u00e7lar\u0131.
\n* \u0130leri Seviye:<\/strong> Performans analizi, b\u00fcy\u00fck dosyalar\u0131n i\u015flenmesi, hata y\u00f6netimi ve \u00f6zel durumlar (edge cases).<\/p>\n

1. Temel Kavramlar: PowerShell ve CSV Dosyalar\u0131<\/strong><\/p>\n

PowerShell, Windows i\u015fletim sistemlerinde yerle\u015fik olarak gelen g\u00fc\u00e7l\u00fc bir komut sat\u0131r\u0131 kabu\u011fu ve betik dilidir. CSV dosyalar\u0131 ise virg\u00fcl ile ayr\u0131lm\u0131\u015f de\u011ferlerden olu\u015fan, verileri d\u00fczenli bir \u015fekilde saklamak i\u00e7in kullan\u0131lan metin dosyalar\u0131d\u0131r. PowerShell’de CSV dosyalar\u0131n\u0131 i\u015flemek i\u00e7in Import-Csv<\/code> cmdlet’ini kullan\u0131r\u0131z. Bu cmdlet, CSV dosyas\u0131n\u0131 okuyup her sat\u0131r\u0131 bir PowerShell nesnesine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. Bu nesneler, s\u00fctun isimlerini \u00f6zellik olarak kullanarak eri\u015filebilir.<\/p>\n

\u00d6rne\u011fin, musteriler.csv<\/code> adl\u0131 bir dosyam\u0131z oldu\u011funu ve bu dosyan\u0131n “Ad”, “Soyad”, “\u015eehir” s\u00fctunlar\u0131n\u0131 i\u00e7erdi\u011fini varsayal\u0131m. Import-Csv<\/code> cmdlet’i ile bu dosyay\u0131 okudu\u011fumuzda, her sat\u0131r bir nesne haline gelir ve bu nesnelerin “Ad”, “Soyad”, “\u015eehir” \u00f6zellikleri olur. Bu \u00f6zelliklere eri\u015ferek istedi\u011fimiz s\u00fctunlara ula\u015fabiliriz.<\/p>\n

2. Nas\u0131l Yap\u0131l\u0131r? CSV Dosyas\u0131n\u0131 Okuma ve Belirli S\u00fctunlar\u0131 Se\u00e7me (Yeni Ba\u015flayan)<\/strong><\/p>\n

\u0130lk olarak, basit bir \u00f6rnek ile ba\u015flayal\u0131m. A\u015fa\u011f\u0131daki kod, musteriler.csv<\/code> dosyas\u0131n\u0131 okur ve sadece “Ad” ve “Soyad” s\u00fctunlar\u0131n\u0131 ekrana yazd\u0131r\u0131r:<\/p>\n

Import-Csv -Path "musteriler.csv" | Select-Object -Property Ad, Soyad<\/code><\/pre>\n
Bu kodda, Import-Csv<\/code> cmdlet’i musteriler.csv<\/code> dosyas\u0131n\u0131 okur.  Select-Object<\/code> cmdlet’i ise  -Property<\/code> parametresi ile belirtilen “Ad” ve “Soyad” s\u00fctunlar\u0131n\u0131 se\u00e7er ve sonu\u00e7lar\u0131 konsola yazd\u0131r\u0131r.  E\u011fer musteriler.csv<\/code> dosyan\u0131z yoksa, kendiniz olu\u015fturabilirsiniz. \u00d6rne\u011fin, Notepad ile a\u015fa\u011f\u0131daki i\u00e7eri\u011fi musteriler.csv<\/code> olarak kaydedebilirsiniz:<\/p>\n
Ad,Soyad,\u015eehir\nAhmet,Y\u0131lmaz,Ankara\nAy\u015fe,Kara,\u0130stanbul\nMehmet,\u00d6z,\u0130zmir<\/code><\/pre>\n
Bu basit \u00f6rnek, PowerShell’in CSV dosyalar\u0131n\u0131 i\u015flemek i\u00e7in ne kadar kolay oldu\u011funu g\u00f6stermektedir.  Daha detayl\u0131 bilgi i\u00e7in [Fatih Soysal’\u0131n PowerShell e\u011fitimlerine](https:\/\/fatihsoysal.com) g\u00f6z atabilirsiniz.<\/p>\n
3. Ger\u00e7ek Hayat \u00d6rne\u011fi: M\u00fc\u015fteri Verilerinin \u0130\u015flenmesi (Orta Seviye)<\/strong><\/p>\n
Bir e-ticaret \u015firketinde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z\u0131 ve m\u00fc\u015fteri verilerinin bulundu\u011fu b\u00fcy\u00fck bir musteriler.csv<\/code> dosyan\u0131z oldu\u011funu d\u00fc\u015f\u00fcnelim.  Bu dosyada y\u00fczlerce s\u00fctun ve binlerce sat\u0131r bulunmaktad\u0131r.  Sizden sadece m\u00fc\u015fterinin ad\u0131, soyad\u0131, \u015fehri ve sipari\u015f tarihi bilgilerini i\u00e7eren yeni bir rapor olu\u015fturman\u0131z isteniyor.  A\u015fa\u011f\u0131daki kod bu i\u015flemi ger\u00e7ekle\u015ftirir:<\/p>\n
$musteriler = Import-Csv -Path "musteriler.csv"\n$rapor = $musteriler | Select-Object Ad, Soyad, \u015eehir, SiparisTarihi\n$rapor | Export-Csv -Path "musteri_raporu.csv" -NoTypeInformation<\/code><\/pre>\n
Bu kodda, \u00f6nce t\u00fcm m\u00fc\u015fteri verilerini $musteriler<\/code> de\u011fi\u015fkenine at\u0131yoruz. Sonra Select-Object<\/code> cmdlet’i ile gerekli s\u00fctunlar\u0131 se\u00e7iyoruz ve sonucu $rapor<\/code> de\u011fi\u015fkenine at\u0131yoruz.  Son olarak Export-Csv<\/code> cmdlet’i ile yeni bir CSV dosyas\u0131 olu\u015fturuyoruz. -NoTypeInformation<\/code> parametresi, \u00e7\u0131kt\u0131 dosyas\u0131na PowerShell tipi bilgilerinin eklenmesini engeller.  Bu \u00f6rnek, ger\u00e7ek d\u00fcnya senaryolar\u0131nda PowerShell’in nas\u0131l kullan\u0131labilece\u011fini g\u00f6stermektedir.  Ayr\u0131ca, verileri i\u015flemeden \u00f6nce okuyup bir de\u011fi\u015fkene atama performans a\u00e7\u0131s\u0131ndan daha verimli olabilir.<\/p>\n
4.  Performans Optimizasyonu: B\u00fcy\u00fck Dosyalar \u0130\u00e7in \u0130pu\u00e7lar\u0131 (Orta Seviye)<\/strong><\/p>\n
B\u00fcy\u00fck CSV dosyalar\u0131 ile \u00e7al\u0131\u015f\u0131rken performans \u00f6nemlidir.  \u0130\u015fte birka\u00e7 performans optimizasyon ipucu:<\/p>\n
* -ReadCount<\/code> Parametresi:<\/strong> Import-Csv<\/code> cmdlet’inin -ReadCount<\/code> parametresi, dosyay\u0131 ka\u00e7 sat\u0131rda okuyaca\u011f\u0131n\u0131 belirtir.  B\u00fcy\u00fck dosyalar i\u00e7in daha y\u00fcksek bir de\u011fer kullanmak performans\u0131 art\u0131rabilir.  \u00d6rne\u011fin, Import-Csv -Path \"musteriler.csv\" -ReadCount 1000<\/code>  her seferinde 1000 sat\u0131r okur.<\/p>\n
* Paralel \u0130\u015fleme:<\/strong>  PowerShell’in paralel i\u015fleme yeteneklerini kullanarak, b\u00fcy\u00fck dosyalar\u0131 daha h\u0131zl\u0131 i\u015fleyebilirsiniz.  ForEach-Object -Parallel<\/code> cmdlet’i ile her sat\u0131r\u0131 ayr\u0131 bir i\u015f par\u00e7ac\u0131\u011f\u0131nda i\u015fleyebilirsiniz. Ancak, bu yakla\u015f\u0131m her zaman performans art\u0131\u015f\u0131 sa\u011flamayabilir, \u00f6zellikle k\u00fc\u00e7\u00fck dosyalar i\u00e7in.<\/p>\n
* Gerekli S\u00fctunlar\u0131 Se\u00e7mek:<\/strong> Sadece gerekli s\u00fctunlar\u0131 se\u00e7mek, gereksiz veri i\u015flemeyi azalt\u0131r ve performans\u0131 art\u0131r\u0131r.  Select-Object<\/code> cmdlet’ini etkili bir \u015fekilde kullan\u0131n.<\/p>\n
5.  Hata Y\u00f6netimi ve \u00d6zel Durumlar (Edge Cases) (\u0130leri Seviye)<\/strong><\/p>\n
Ger\u00e7ek d\u00fcnya verileri her zaman m\u00fckemmel olmaz.  Eksik veriler, yanl\u0131\u015f formatlanm\u0131\u015f veriler veya di\u011fer beklenmedik durumlarla kar\u015f\u0131la\u015fabilirsiniz.  Bu durumlar\u0131 ele almak i\u00e7in hata y\u00f6netimi \u00f6nemlidir.  try...catch<\/code> bloklar\u0131 kullanarak hatalar\u0131 yakalayabilir ve uygun \u015fekilde yan\u0131t verebilirsiniz.<\/p>\n
try {\n    $musteriler = Import-Csv -Path "musteriler.csv"\n    # ... di\u011fer kodlar ...\n}\ncatch {\n    Write-Error "CSV dosyas\u0131n\u0131 okumada hata olu\u015ftu: $_"\n}<\/code><\/pre>\n
Ayr\u0131ca, verilerin do\u011fru formatta olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in do\u011frulama i\u015flemleri ekleyebilirsiniz.  \u00d6rne\u011fin, bir s\u00fctunun say\u0131sal bir de\u011fer i\u00e7ermesi gerekti\u011fini biliyorsan\u0131z, bunu do\u011frulayabilir ve hatal\u0131 verileri filtreleyebilirsiniz.<\/p>\n
6.  Performans Analizi: \u0130\u015flemlerin S\u00fcresini \u00d6l\u00e7me (\u0130leri Seviye)<\/strong><\/p>\n
Kodunuzun performans\u0131n\u0131 \u00f6l\u00e7mek ve iyile\u015ftirmeler yapmak i\u00e7in PowerShell’in zaman \u00f6l\u00e7\u00fcm yeteneklerini kullanabilirsiniz.  Measure-Command<\/code> cmdlet’i, bir kod blo\u011funun ne kadar s\u00fcrd\u00fc\u011f\u00fcn\u00fc \u00f6l\u00e7menizi sa\u011flar.<\/p>\n
Measure-Command {\n    Import-Csv -Path "musteriler.csv" | Select-Object Ad, Soyad\n}<\/code><\/pre>\n
Bu kod, Import-Csv<\/code> ve Select-Object<\/code> cmdlet’lerinin birlikte \u00e7al\u0131\u015fmas\u0131n\u0131n ne kadar s\u00fcrd\u00fc\u011f\u00fcn\u00fc \u00f6l\u00e7er ve sonucu konsola yazd\u0131r\u0131r.  Bu \u00f6l\u00e7\u00fcmler, performans optimizasyon \u00e7al\u0131\u015fmalar\u0131n\u0131z i\u00e7in de\u011ferli bilgiler sa\u011flar.<\/p>\n
7.  Karma\u015f\u0131k Filtreleme ve Veri \u0130\u015fleme (\u0130leri Seviye)<\/strong><\/p>\n
Where-Object<\/code> cmdlet’i ile verileri filtreleyebilirsiniz.  \u00d6rne\u011fin, sadece Ankara’da ya\u015fayan m\u00fc\u015fterileri se\u00e7mek i\u00e7in a\u015fa\u011f\u0131daki kodu kullanabilirsiniz:<\/p>\n
$musteriler = Import-Csv -Path "musteriler.csv" | Where-Object {$_.\u015eehir -eq "Ankara"}<\/code><\/pre>\n
Ayr\u0131ca, calculated properties<\/code> kullanarak yeni s\u00fctunlar ekleyebilir veya mevcut s\u00fctunlar\u0131 manip\u00fcle edebilirsiniz.  \u00d6rne\u011fin, ad ve soyad\u0131 birle\u015ftirerek “TamAd” adl\u0131 yeni bir s\u00fctun ekleyebilirsiniz:<\/p>\n
$musteriler = Import-Csv -Path "musteriler.csv" | Select-Object *, @{Name="TamAd";Expression={$_.Ad + " " + $_.Soyad}}<\/code><\/pre>\n
8.  PowerShell ile Veri Analizi ve Raporlama (\u0130leri Seviye)<\/strong><\/p>\n
PowerShell, sadece veri \u00e7\u0131karmakla kalmaz, ayn\u0131 zamanda veri analizi ve raporlama i\u00e7in de kullan\u0131labilir.  Group-Object<\/code> cmdlet’i ile verileri gruplayabilir ve Measure-Object<\/code> cmdlet’i ile istatistiksel hesaplamalar yapabilirsiniz. Bu, \u00f6rne\u011fin, her \u015fehirdeki m\u00fc\u015fteri say\u0131s\u0131n\u0131 veya ortalama sipari\u015f tutar\u0131n\u0131 hesaplaman\u0131za olanak tan\u0131r.<\/p>\n
Sonu\u00e7<\/strong><\/p>\n
PowerShell, CSV dosyalar\u0131ndan belirli s\u00fctunlar\u0131 \u00e7\u0131karmak i\u00e7in g\u00fc\u00e7l\u00fc ve esnek bir ara\u00e7t\u0131r. Bu makalede, temel kavramlardan ileri seviye tekniklere kadar, ad\u0131m ad\u0131m bir rehber sunduk.  Ger\u00e7ek d\u00fcnya \u00f6rnekleri ve performans optimizasyon ipu\u00e7lar\u0131 ile, PowerShell’in veri i\u015flemedeki g\u00fcc\u00fcn\u00fc ke\u015ffetmenize yard\u0131mc\u0131 olduk.  Unutmay\u0131n, b\u00fcy\u00fck dosyalarda performans \u00f6nemlidir ve do\u011fru teknikleri kullanarak i\u015fleme s\u00fcresini \u00f6nemli \u00f6l\u00e7\u00fcde azaltabilirsiniz.<\/p>\n
S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n
1. Hata mesajlar\u0131 nas\u0131l ele al\u0131n\u0131r?<\/strong>  try...catch<\/code> bloklar\u0131 kullanarak hatalar\u0131 yakalayabilir ve uygun \u015fekilde yan\u0131t verebilirsiniz.<\/p>\n
2. B\u00fcy\u00fck CSV dosyalar\u0131 i\u00e7in en iyi uygulama nedir?<\/strong>  -ReadCount<\/code> parametresini kullan\u0131n, paralel i\u015flemeyi de\u011ferlendirin ve sadece gerekli s\u00fctunlar\u0131 se\u00e7in.<\/p>\n
3. CSV dosyas\u0131nda \u00f6zel karakterler varsa ne olur?<\/strong>  PowerShell, \u00f6zel karakterleri genellikle do\u011fru \u015fekilde i\u015fler. Ancak, sorun ya\u015farsan\u0131z, kodunuzu buna g\u00f6re uyarlaman\u0131z gerekebilir.<\/p>\n
4. Farkl\u0131 ay\u0131r\u0131c\u0131lar (\u00f6rne\u011fin, sekme) kullanan CSV dosyalar\u0131 nas\u0131l i\u015flenir?<\/strong>  Import-Csv<\/code> cmdlet’inin -Delimiter<\/code> parametresini kullanarak ay\u0131r\u0131c\u0131y\u0131 belirleyebilirsiniz.<\/p>\n
5. PowerShell’de daha geli\u015fmi\u015f veri analizi nas\u0131l yap\u0131l\u0131r?<\/strong>  PowerShell’in yerle\u015fik cmdlet’lerini ve ayr\u0131ca \u00fc\u00e7\u00fcnc\u00fc parti mod\u00fclleri kullanarak daha geli\u015fmi\u015f analizler yapabilirsiniz.<\/p>\n
Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PowerShell: CSV’den Belirli S\u00fctunlar\u0131 \u00c7\u0131karma G\u00fcn\u00fcm\u00fczde veri i\u015fleme, her \u00f6l\u00e7ekteki i\u015fletme i\u00e7in vazge\u00e7ilmez bir ihtiya\u00e7t\u0131r. Veri genellikle…","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1319],"tags":[],"class_list":{"0":"post-29332","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-powershell","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"\nPowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)<\/title>\n<meta name=\"description\" content=\"Hi\u00e7bir etiketi bulunamad\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:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-11T09:10:38+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)\",\"datePublished\":\"2025-09-11T09:10:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/\"},\"wordCount\":1250,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PowerShell\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/\",\"name\":\"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-09-11T09:10:38+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)","description":"Hi\u00e7bir etiketi bulunamad\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:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/","og_locale":"tr_TR","og_type":"article","og_title":"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-09-11T09:10:38+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)","datePublished":"2025-09-11T09:10:38+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/"},"wordCount":1250,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PowerShell"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/","url":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/","name":"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-09-11T09:10:38+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/powershell-import-csv-and-extract-specific-columns-ceviri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PowerShell: Import CSV and Extract Specific Columns (\u00c7eviri)"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/29332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=29332"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/29332\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=29332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=29332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=29332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}