Scripting. Powershell, VMware, Windows, Active Directory & Exchange. All that kind of stuff…..
RSS icon Email icon Home icon
  • PowerShell 2.0: One Cmdlet at a Time #83 ConvertTo-CSV

    Posted on March 24th, 2010 Jonathan Medd No comments

    Continuing the series looking at new cmdlets available in PowerShell 2.0. This time we look at the ConvertTo-CSV cmdlet.

    What can I do with it?

    Convert a .NET object into a series of CSV style strings.

    Example:

    Retrieve a list of services beginning with the letter b and convert the object into CSV style strings

    Get-Service | Where-Object{$_.Name -like 'b*'}
    | ConvertTo-CSV -NoTypeInformation

    You will notice that the data returned from the services has been converted into strings separated by a comma. (The names of the services are highlighted in yellow.)

    ConvertTo-CSV

    How could I have done this in PowerShell 1.0?

    You could have used Export-CSV, but that would have put the information into a file.

    1000 things 1% better!

    Leave a reply