替换csv文件的行开始值。

Question

嗨，我需要一点帮助

我需要更改csv第一列的第一个值。

"A"; "B"; "C"; "D"
"1"; Rome";" Italy";"12/1/2023"
"2"; "Milan";"Italy";"2/11/2023"
"3"; "Firneze"; "Italy";"13/3/2021"

里乌斯特

"A"; "B"; "C"; "D"
"one"; Rome";" Italy";"12/1/2023"
"two"; "Milan";"Italy";"2/11/2023"
"three"; "Firneze"; "Italy";"13/3/2021"

使用替换命令显然也会更改日期

-replace '1' , 'one' 

这是错误的结果

"A"; "B"; "C"; "D"
"one"; Rome";" Italy";"12/one/2023"

你能帮我吗？

文件csv原版

"cycle";"support";"eol";"latest";"releaseDate";"OS"
"9";"2027-05-31";"2027-05-31";"9";"2021-09-15";"Centos"
"stream-8";"2024-05-31";"2024-05-31";"8";"2019-09-24";"Centos"
"8";"2021-12-31";"2021-12-31";"8 (2111)";"2019-09-24";"Centos"
"7";"2020-08-06";"2024-06-30";"7 (2009)";"2014-07-07";"Centos"
"6";"2017-05-10";"2020-11-30";"6.10";"2011-07-10";"Centos"

quello di cui ho bisogno

"cycle";"support";"eol";"latest";"releaseDate";"OS"
"Release 9.";"2027-05-31";"2027-05-31";"9";"2021-09-15";"Centos"
"Release stream 8.";"2024-05-31";"2024-05-31";"8";"2019-09-24";"Centos"
"Release 8.";"2021-12-31";"2021-12-31";"8 (2111)";"2019-09-24";"Centos"
"Release 7.";"2020-08-06";"2024-06-30";"7 (2009)";"2014-07-07";"Centos"
"Release 6.";"2017-05-10";"2020-11-30";"6.10";"2011-07-10";"Centos"

Answer 1

通过使用import-csv导入CSV，这样您就可以得到一个对象数组，这样您就可以只针对要更新的属性。

#load csv
$csv = import-csv [path] -delimiter ";"

#loop and set value of property cycle
$csv | %{
    $_.cycle = 'Release ' + $_.cycle
}

#output new csv to file
$csv | export-csv [path]