Assign only object value from csv to a variable

Question

With some help I was able to import the .CSV file and read the first and last row elements, but I want to assign only the batch id to a variable, but when I include it in a email body, I get the whole object rather than value.

    $getBatchIds=(Import-csv $file.FullName)
    $firstElement= $getBatchIds | Select-Object -First 1 batch_id
    $lastElement= $getBatchIds | Select-Object -Last 1  batch_id

$getBatchIds to import the file

$firstElement $lastElement to get the last row elements

This is the object that is included in the email body, that assigns them to individual variables and I output them in the email body

1       12-06-2019 07:54:47 @{Batch_Id=2129475} @{Batch_Id=2138701}

2       11-06-2019 09:40:41 @{Batch_Id=2103516} @{Batch_Id=2129456}

what is the question? i don't understand your post ... [blush] — Lee_Dailey
– Lee_Dailey, Commented Jun 13, 2019 at 8:54

mhu · Accepted Answer · 2019-06-13 09:28:08Z

1

Use -ExpandProperty:

$getBatchIds  = Import-Csv -Path $file.FullName
$firstElement = $getBatchIds | Select-Object -First 1 -ExpandProperty "batch_id"
$lastElement  = $getBatchIds | Select-Object -Last 1 -ExpandProperty "batch_id"

answered Jun 13, 2019 at 9:28

mhu

18.1k10 gold badges67 silver badges97 bronze badges

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

Collectives™ on Stack Overflow

Assign only object value from csv to a variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related