Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
468 views
in Technique[技术] by (71.8m points)

csv - 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"

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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

 $case."Remaining Time - Hours"

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...