在 csv 导入中修剪对象内容 [英] trim object contents in csv import

问题描述

我需要对从 csv 导入对象中提取的每个值运行一个修剪方法.还没有尝试过类似下面的东西，但对我来说，我不想在传递给函数的每个变量的末尾定义一个修剪命令.

I need to run a trim method on each value extracted from the csv import object. haven't tried something like below but for me I don't want to have to define a trim command at the end of each one of my variables being passed to functions.

$csvobj = "c:\somestuff.csv"

foreach ($csvitem in $csvobj) {
$csvitem.value1.trim()
$csvitem.value2.trim()
}

提前致谢，SS

推荐答案

这将修剪 csv 文件中的所有值并将结果分配给 $csv.

This will trim all values in the csv file and assign the result to $csv.

$csv = Import-Csv c:\somestuff.csv | Foreach-Object {
   $_.PSObject.Properties | Foreach-Object {$_.Value = $_.Value.Trim()}  
}

这篇关于在 csv 导入中修剪对象内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！