Sum values from input-csv

Question

i have a csv sheet like one given below, (some cells can be empty, actual sheet i have is having upto disk 20),

ID   name disk1 disk2 disk3
001  abc  50    50    50 
002  def  100   100     
003  xyz  50

I need to input this sheet to powershell script and add all three "disk" fields alone for each record and print it out, something like given below, only sum is sufficient not required ID or name fields, preferably i need a function to call for each record to return back the sum

150
200
50

tried this so far but no luck

$coll = import-csv "C:\input.csv"
foreach ($record in $coll)
{
    for ($i=1; $i -lt 4; $i++)
    {
        [int]$totaldisk = @()
        $diskname = "disk"+$i
        $totaldisk += $record.$diskname
    }
    $totaldisk
 }

What have you tried so far? I'd suggest starting with Import-Csv then using foreach-object to perform calculations — LinkBerest - SO sold our work
– LinkBerest - SO sold our work, Commented Jun 22, 2015 at 2:33

Mike Shepard · Accepted Answer · 2015-06-22 03:48:03Z

2

It looks like you were really close. You just initialized $totaldisk wrong (and in the wrong place).

$coll = import-csv "C:\input.csv"
foreach ($record in $coll)
{
    $totaldisk =0
    for ($i=1; $i -lt 4; $i++)
    {

        $diskname = "disk"+$i
        $totaldisk += $record.$diskname
    }
    $totaldisk
 }

answered Jun 22, 2015 at 3:48

Mike Shepard

18.4k7 gold badges59 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

LinkBerest - SO sold our work Over a year ago

I know I've done with Measure-Object and select but I'm far too tired to remember how apparently, so +1 to you.

Mike Shepard Over a year ago

The problem with measure-object is that it looks at properties across objects rather than within objects (if that makes sense). It could sum all the disk1's together and so on, but not disk1+disk2...

LinkBerest - SO sold our work Over a year ago

yeah, I must just be way too tired.

sureshv18 Over a year ago

@AnsgarWiechers Done now. Was new to this forum and was not aware how to mark as accepted earlier.

Collectives™ on Stack Overflow

Sum values from input-csv

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related