Skip to content

Instantly share code, notes, and snippets.

@kpatnayakuni
Last active January 18, 2019 02:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kpatnayakuni/dab0f1c99d34fc18f869451d93efe76e to your computer and use it in GitHub Desktop.
Save kpatnayakuni/dab0f1c99d34fc18f869451d93efe76e to your computer and use it in GitHub Desktop.
$File = 'C:\Windows\Temp\delete.csv'
$Content = Get-Content -Path $File
<# File content
GroupA,GroupB,GroupC,1,2
GroupB,GroupC,GroupD,1,2,3,4,5
GroupA,GroupC,GroupE,1
GroupA,GroupB,GroupE,1,2,3,4
GroupC,GroupD,GroupE,1,2,3
#>
foreach ($row in $Content)
{
$rowvalues = $row.split(',')
$rowsum = ($rowvalues[3..$($rowvalues.Length)]|Measure-Object -Sum).Sum
($rowvalues[0..2] + $rowsum) -join ','
}
<# Output
GroupA,GroupB,GroupC,3
GroupB,GroupC,GroupD,15
GroupA,GroupC,GroupE,1
GroupA,GroupB,GroupE,10
GroupC,GroupD,GroupE,6
#>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment