我有許多檔案我想從每個檔案中讀取一個特定的列，然后將每個檔案輸出到一個新的 csv 檔案，每個檔案都作為一個新列讀入。我目前正在讀取并輸出到一個新檔案，但是它將所有內容輸出到一列中，我如何分離出每個檔案資料？
這就是我目前擁有的
Import-Csv -Delimiter "`t" -Header @("a","b","c","d","e","f","g","h","i") (Get-ChildItem -path C:\Users\xxxxx *.tsv) |
select g |
Export-Csv newfile.csv -NoType
uj5u.com熱心網友回復：
將輸出Get-ChildItem作為輸入提供給ForEach-Object，然后分別從每個檔案中匯入/提取/匯出：
Get-ChildItem -path C:\Users\xxxxx *.tsv |ForEach-Object {
Import-Csv -LiteralPath $_.FullName -Delimiter "`t" -Header @("a","b","c","d","e","f","g","h","i") |
Select-Object g |
Export-Csv ($_.BaseName '_newfile.csv') -NoTypeInformation
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/531489.html