<div>
Filter null values out of the feed sent to Export-CSV with a Where-Object {$_} 
 
<a href="http://en.community.dell.com/techcenter/powergui/f/4834/t/19571829.aspx" rel="ugc nofollow">http://en.community.dell.com/techcenter/powergui/f/4834/t/19571829.aspx</a>
</div>

Filter null values out of the feed sent to Export-CSV with a Where-Object {$_}

http://en.community.dell.com/techcenter/powergui/f/4834/t/19571829.aspx [http://en.community.dell.com/techcenter/powergui/f/4834/t/19571829.aspx]

<div>
The error is that &nbsp; &nbsp;$exportlist | Export-Csv -Path &quot;\\MyServer\MyLocation\MyExport.csv&quot; needs to be outside of the foreach. But the code Subsun showned is better, not using any intermediate variables.
</div>

The error is that    $exportlist | Export-Csv -Path "\\MyServer\MyLocation\MyExport.csv" needs to be outside of the foreach. But the code Subsun showned is better, not using any intermediate variables.

<div>
<div class="content wysiwyg-content">
Hi, am running following powershell script, and I ran into an error. 
 
Add-PSSnapin Microsoft.Sharepoint.PowerShell 
 
 
$MyWeb = Get-SPWeb &quot;<a href="http://MySite" rel="ugc">http://MySite</a>&quot; 
$MyList = $MyWeb.Lists[&quot;MyList&quot;] 
$exportList = @() 
$MyList.Items | foreach{ 
$obj = New-Object PSObject -Property @{ 
&nbsp; &nbsp; &quot;ID&quot; = $_[&quot;ID&quot;] 
&nbsp; &nbsp; &nbsp;&quot;Content Type&quot; = $_[&quot;P. Type&quot;] 
&nbsp; &nbsp; &nbsp;&quot;Program Name&quot; = $_[&quot;Program Name&quot;] 
&nbsp; &nbsp; &nbsp;&quot;Classifications&quot; = ($_[&quot;Classifications&quot;]).substring(($_[&quot;Classifications&quot;]).IndexOf(&quot;#&quot;)+1) 
&nbsp; &nbsp; &nbsp;&quot;Classifications ID&quot; = ($_[&quot;Classifications&quot;]).split(&quot;;&quot;)[0] 
&nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; 
} 
 
&nbsp; 
&nbsp; $exportList += $obj 
&nbsp; $exportlist | Export-Csv -Path &quot;\\MyServer\MyLocation\MyExport.csv&quot; 
 
} 
 
Error: Export-CSV : Cannot bind argument to parameter ‘InputObject’ because it is null.
</div>
</div>

Hi, am running following powershell script, and I ran into an error.

Add-PSSnapin Microsoft.Sharepoint.PowerShell


$MyWeb = Get-SPWeb "http://MySite"
$MyList = $MyWeb.Lists["MyList"] 
$exportList = @()
$MyList.Items | foreach{
$obj = New-Object PSObject -Property @{
    "ID" = $_["ID"]
     "Content Type" = $_["P. Type"]
     "Program Name" = $_["Program Name"]
     "Classifications" = ($_["Classifications"]).substring(($_["Classifications"]).IndexOf("#")+1)
     "Classifications ID" = ($_["Classifications"]).split(";")[0]
     
       
}

 
  $exportList += $obj
  $exportlist | Export-Csv -Path "\\MyServer\MyLocation\MyExport.csv"

}

Error: Export-CSV : Cannot bind argument to parameter ‘InputObject’ because it is null.

Powershell help

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.