Search code examples
powershellcsv

Powershell: Reference a property that contains a space

I am importing a CSV file using powershell.

The problem is, the title of one of the columns is "Remaining Time - Hours". So I'm getting a sequence of objects, and it's actually assigned the property "Remaining Time - Hours".

What is the syntax to refer to this property?

eg

Import-Csv AllOpenCases.csv | % {$case = $_ }
$case | get-member

returns

Category               : Inquiry
Starred                : No
Remaining Time - Hours : 22.5

but if I type

$case.Remaining Time - Hours

I get "Unexpected token 'Time' in expression or statement"

Solution

  • Properties with embedded spaces have to be quoted when they're referenced:

     $case."Remaining Time - Hours"