Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Powershell: Reference a property that contains a space

Tags:

powershell

csv

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"

like image 393
Andrew Shepherd Avatar asked Feb 01 '11 00:02

Andrew Shepherd


1 Answers

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

 $case."Remaining Time - Hours" 
like image 74
mjolinor Avatar answered Sep 29 '22 07:09

mjolinor