Mastering Windows PowerShell Scripting - Second Edition: One-stop guide to automating administrative tasks by Dent Chris & Blawat Brenton J.W

Author:Dent, Chris & Blawat, Brenton J.W. [Dent, Chris]
Language: eng
Format: azw3
Publisher: Packt Publishing
Published: 2017-10-27T04:00:00+00:00

Working with CSV

ConvertTo-Csv turns objects in PowerShell into CSV (comma-separated values) strings:

PS> Get-Process -Id $pid | Select-Object Name, Id, Path | ConvertTo-Csv

#TYPE Selected.System.Diagnostics.Process

"Name","Id","Path"

"powershell_ise","9956","C:\WINDOWS\System32\WindowsPowerShell\v1.0\powershell_ise.exe"

ConvertFrom-Csv turns CSV formatted strings into objects. For example:

"David,0123456789,28" | ConvertFrom-Csv -Header Name, Phone, Age

As ConvertFrom-Csv is specifically written to read CSV formatted data, it will discard quotes surrounding strings, but will allow fields to spread across lines and so on. For example:

'David,0123456789,28,"1 Some street, A Lane"' | ConvertFrom-Csv -Header Name, Phone, Age, Address | Format-Table -Wrap

If the Header parameter is not defined, the first line ConvertFrom-Csv reads is expected to be a header. If there is only one line of data nothing will be returned:

'Name,Age', 'David,28' | ConvertFrom-Csv

Export-Csv and Import-Csv complement these two commands by writing and reading information to a file instead:

Get-Process -Id $pid | Select-Object Name, Id, Path | Export-Csv 'somefile.csv' Import-Csv somefile.csv

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.