Check whether CSV header is present and read data to an array

Question

Hi,

I have a csv file which has below data.

I want to compare the headers to a predefined value to check whether the OS exists in the csv file. If it exists, I want to read the data in that column in to an array.

Anybody can help me with how can I achieve this in PowerShell?

Thanks in advance.

Answer 1

Hi，

You could try something like below

$file = "C:\temp\file.csv"  
$os = "Windows 10"  
$content= Import-Csv -Path $file  
$headers = ($content | Get-Member -MemberType NoteProperty).Name  
if($os -in $headers){  
   $kb =  $content.$os  
}  

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.