Powershell CSV with headers to hashtable

Question

I have a csv file with a header row and I want to convert it to a Hashtable.

For example, this is my input:

#Version1.0
#Fields:ID,Data
1,data1
2,data2
3,data3

I want the output to be a hashtable where Key=ID and Value =Data.

This is what I have, but the results aren't quite what I want.

$mytable = Import-Csv -Path $filePath -Header ID,Data
$HashTable=@{}
foreach($r in $mytable)
{
    $HashTable[$r.ID]=$r.Data
}

This creates my table, but when I output it later via $str = $Hashtable | Out-String Write-Host $str

I'm getting the following:

Name                  Value
--------              -----------
#Fields:ID            Data
1                     data1
2                     data2
3                     data3

How do I get rid of the Headers being written to my hashtable? Is there a more elegant solution than sticking if ($r.ID.StartsWith("#")) { continue; }?

Thanks! -C

Answer 1

The default behavior in Import-Csv is to use the first (un-commented) line as the headers. Instead of defining the header in the command, remove "#Fields:" from the header line.

#Version1.0
ID,Data
1,data1
2,data2
3,data3

Then you can create the hashtable like this:

$mytable = Import-Csv -Path $filePath
$HashTable=@{}
foreach($r in $mytable)
{
    $HashTable[$r.ID]=$r.Data
}

Which returns:

Name                           Value
----                           -----
2                              data2
1                              data1
3                              data3

Answer 2

$HashTable = @{}
Import-Csv $filePath | % { $HashTable[$_.ID] = $_.Data }

Answer 3

You can try this :

Get-Content $filePath | where {$_ -notmatch '^#'} | ConvertFrom-Csv -Header ID,Data

It remove all the lines begining with # before readingg then as CSV lines.