powershell - CSV remove column by header name

Question

I am working on a little PowerShell script that should remove a named column. Is there a way to not NOT select a column with header name "xyz"?

I tried to get the header names by

$hnames = $csv | Get-Member -MemberType NoteProperty | foreach {$_.name}

and join the result into a comma separated string and remove the unwanted header

$new = $hnames -join ","
$new = $new -replace "xyz,", ""

and import/export the CSV with select

Import-CSV $tempfile -Delimiter ";" | Select $new |
    Export-Csv tempynew.csv -Delimiter ";" -Encoding UTF8 -NoTypeInfo   

but it only outputs the header in the CSV file.

Answer 1

Use the -ExcludeProperty parameter with Select-Object instead:

Import-Csv $tempfile -Delimiter ";" | Select * -ExcludeProperty xyz |
    Export-Csv tempynew.csv -Delimiter ";" -Encoding UTF8 -notypeinfo