Contact Info

Crumbtrail

ActiveXperts.com » Administration » Powershell » Powershell 2.0 » Export-CSV

Export-CSV - Powershell 2.0 CmdLet

ActiveXperts Network Monitor ships with integrated Powershell scripts to monitor complex network. The scripts run out of the box
Download the ActiveXperts Network Monitor FREE version now »

Export-CSV

Short description
Converts Microsoft .NET Framework objects into a series of comma-separated value (CSV) variable-length strings and 
    saves the strings in a CSV file.

Syntax


Description
The Export-CSV cmdlet creates a CSV variable-length file that represents the objects that you submit. 
    You can then use the Import-CSV cmdlet to re-create objects from the CSV strings in the files. The resulting object
    s are CSV versions of the original objects that consist of string representations of the property values and no met
    hods.
    
    You can also use the ConvertTo-CSV and ConvertFrom-CSV cmdlets to convert .NET Framework objects to CSV strings (an
    d back). Export-CSV is the same as ConvertTo-CSV, except that it saves the CSV strings in a file.
    
    You can use the parameters of the Export-CSV cmdlet to specify a delimiter other than a comma or to direct Export-C
    SV to use the default delimiter for the current culture. 
    
    When you submit multiple objects to Export-CSV, Export-CSV organizes the file based on the properties of the first 
    object that you submit. If the remaining objects do not have one of the specified properties, the property value of
     that object is null, as represented by two consecutive commas. If the remaining objects have additional properties
    , those property values are not included in the file.
    
    For more information, see Export-CSV, and see the Notes section.