powershell - csv文件的ForEach-Object调用属性从没有空格变为有空格

Question

由于最近的变化，这几乎是此的延续 - Remove leading zeros in csv file from int values only

我有以下代码:

Import-CSV "C:\path\test.csv" | ForEach-Object{
    $_.column1 = ($_.column1).TrimStart('0')
    $_
} | Export-Csv "C:\path\test2.csv" -NoTypeInformation
Move-Item "C:\path\test2.csv" "C:\path\test.csv" -Force

尝试以下代码后:

Import-CSV "C:\path\test.csv" | ForEach-Object{
    $_.column 1 = ($_.column 1).TrimStart('0')
    $_
} | Export-Csv "C:\path\test2.csv" -NoTypeInformation
Move-Item "C:\path\test2.csv" "C:\path\test.csv" -Force

现在，在 csv 文件中 column1已更改为 column 1 (现在有一个空格)。

我收到编译语法错误:

Unexpected token 'One' in expression or statement.
At :line:2 char:19
+       $_.Column One  <<<< = ($_.Column One).TrimStart('0')

对此的任何帮助将不胜感激......

Answer 1

在这个网站上找到了答案:
http://itknowledgeexchange.techtarget.com/powershell/csv-fields-with-spaces-in-the-field-name/

Import-CSV "C:\path\test.csv" | ForEach-Object{
    $_.'column 1' = ($_.'column 1').TrimStart('0')
    $_
} | Export-Csv "C:\path\test2.csv" -NoTypeInformation
Move-Item "C:\path\test2.csv" "C:\path\test.csv" -Force