From the course: PowerShell for SQL Server Administration

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Exporting CSV files

Exporting CSV files - PowerShell Tutorial

From the course: PowerShell for SQL Server Administration

Start my 1-month free trial

Exporting CSV files

“

- [Instructor] Now let's look at exporting data from PowerShell, or using PowerShell to a CSV file. Often times when you're exporting data and working with data in PowerShell, you're going to need to be able to hand that off to something else. A lot of times when you need to hand that data off, you're going to need to hand it off via a CSV file. So that's a comma-separated value file. So when you do that, you can actually do that, hand it off fairly easily in PowerShell 'cause you can export that data fairly easily to CSV in PowerShell and create that CSV file. So whatever data you need, you can do whatever you have to do to manipulate or massage that data in PowerShell. And when you're done with it, you can then export that data down to a CSV to hand off to whatever that third party function or third party application is. So a lot of the times when I'm doing this, I'll have to hand off data to be imported into some other system. Maybe I'll need to create a CSV file that needs to be…

Contents