Powershell Script to Delete Blank Columns from CSV

How about something like this:

$x = Import-Csv YourFile.csv
$f = $x[0] | Get-Member -MemberType NoteProperty | Select name
$f | Add-Member -Name count -Type NoteProperty -Value 0
$f | %{
  $n = $_.Name
  $_.Count = @($x | Select $n -ExpandProperty $n | ? {$_ -ne ''}).count
}
$f = @($f | ? {$_.count -gt 0} | Select Name -expandproperty Name)

$x | Select $f | Export-Csv NewFile.csv -NoTypeInformation

It uses Get-Member to get the column names, cycles though each one to check how many are not blank and then uses the results in a select.

When I run Dave Sexton's code, I get:

Select-Object : Cannot convert System.Management.Automation.PSObject to one of the following 
types {System.String, System.Management.Automation.ScriptBlock}.
At line:15 char:12
+ $x | Select <<<<  $f  | Export-Csv ColsRem.test.$time.csv -NoTypeInformation
+ CategoryInfo          : InvalidArgument: (:) [Select-Object], NotSupportedException
+ FullyQualifiedErrorId : 
                  DictionaryKeyUnknownType,Microsoft.PowerShell.Commands.SelectObjectCommand

I corrected this issue by adding one more line, to force each array element to be a string.

$x = Import-Csv YourFile.csv
$f = $x[0] | Get-Member -MemberType NoteProperty | Select name
$f | Add-Member -Name count -Type NoteProperty -Value 0
$f | %{
  $n = $_.Name
  $_.Count = @($x | Select $n -ExpandProperty $n | ? {$_ -ne ''}).count
}
$f = @($f | ? {$_.count -gt 0} | Select Name -expandproperty Name)

# I could get the select to work with strings separated by commas, but the array would 
# always produce the error until I added the following line, explicitly changing the 
#values to strings.
$f = $f | Foreach-Object { "$_" } 

$x | Select $f | Export-Csv NewFile.csv -NoTypeInformation

My import CSV contains a few hundred columns and about half likely won't be populated, so getting rid of the extra columns was necessary. Now I just need to figure out how to counteract the unintended re-ordering of the columns into alphabetical order by name, without changing the names.

I updated Dave Sexton's great code to not remove columns with $false and only remove empty ones

function Remove-EmptyColumns {

  Param(
    [Parameter(Mandatory=$True)]
    [PSCustomObject[]]$InputObject
  )

  $ColumnNames = $InputObject[0].PSObject.Properties.Name

  $ColumnsToRemove = foreach ($Column in $ColumnNames) {
    $ColumnValues = $InputObject.ForEach{ $_.$Column }
    # Explicitly check for $false or non-empty string
    if ($ColumnValues -contains $false -or 
        $ColumnValues.Where{ $_ -ne $null -and $_ -ne '' }) {
      # Dont remove 
    }
    else {
      $Column # Remove if all empty  
    }
  }

  return $InputObject | Select-Object * -ExcludeProperty $ColumnsToRemove
}