Powershell : Excel data reading issue

Question

I have an issue with a powershell script which is supposed to read data into an excel file (.csv)

My excel content

Request	Request Name
Service 1	SA1
Service 2	SA2
Service 3	SA3

Answer 1

Based on your comments, you can do the following:

$RequestValue = 'Service 2'
(Import-Csv -Delimiter ";" -Path "C:ScriptsTemplates.csv" |
    Where Request -eq $RequestValue).'Request Name'

Having a variable $RequestValue is not necessary, but this is simulating a scenario where you retrieve that value elsewhere in your code. You could use Where Request -eq 'Service 2' instead.

Where is an alias for Where-Object. The syntax where property operator value is used here. The row that meets the criterion property Request has a value of $RequestValue is selected.

Using Member Access Operator (.propertyName), you can retrieve the value of the Request Name property. Since the property name contains a space, you will need to surround it in quotes so it is parsed correctly.