无法在现有的CSV文件中添加额外的列
问题描述：
我有一个.csv文件，其中包含以下数据:
I have a .csv file which contains data as below:
Name ID
ABC 1234
CDE 3456
我正在尝试将名为日期"的列作为第一列.
I am trying to insert a column called "Date" as the first column.
Date Name ID
2018-03-28 ABC 1234
2018-03-28 CDE 3456
我正在使用以下进出口:
I am using below import-export:
$a = Import-Csv -Path c:\filename.csv -Header Date,Name,Id
$a | Export-Csv -Path c:\outfile.csv -NoTypeInformation
但上述方法无法按预期工作.它正在替换列数据.
But above not working as expected. It's displacing the column data.
Date Name Id
ABC 1234
CDE 3456
答
您需要将属性添加到对象:
You need to add the property to the objects:
$a= import-csv -path c:\filename.csv -header Name,Id
foreach($item in $a){
Add-Member -Input $item -MemberType NoteProperty -Name Date -Value '2018-03-28'
}
$a | Select-Object Date, Name, ID | export-csv -path c:\outfile.csv -Notypeinformation