Saving Data: Export-Csv and Cleaning a CSV

Export-Csv saves objects as a CSV file that Excel and other programs open as a table, and on the way there a pipeline can clean an untidy export, dropping its blank rows, renaming its columns and turning text such as $36.00 into numbers with [decimal] and [int].

Updated

Cheat sheet for the lesson Saving Data: Export-Csv and Cleaning a CSV: Export-Csv saves objects as a CSV file that Excel and other programs open as a table, and on the way there a pipeline can clean an untidy export, dropping its blank rows, renaming its columns and turning text such as $36.00…
Category
PowerShell
Level
Journeyman
Tags
Calculated Property, CSV File, export-csv, operating-system, powershell, type-conversion