Powershell - Execute function and then export to CSV

Question

What is the best way of executing a function and exporting the results to csv (file needs to be timestamped)?

I am currently producing a CSV which does not contain the correct details in the correct format.

function Print-Output() {
    $outputString = "hostname,os,lob"

    $Applications.Keys | ForEach-Object {
        $outputString+=",$_"
    }

    $outputString

    $ComputerObjects | ForEach-Object {
        $outputString="$($_.hostname),$($_.os),$($_.lob)"
        $currComputerObject = $_

        $currComputerObject.apps.Keys | ForEach-Object {
            $outputString+=",$($currComputerObject.apps[$_])".ToLower()
        }
        $outputString
    }

    $outputString
}

Print-Output | export-csv "results.csv"

Is the problem that you don't have the right data, or you don't have the right format? IOW, you've only shown "this is what I do" - not "this is what I get, but this other example is what I expect." At first blush, it looks like you're building CSV strings, then calling Export-CSV which will basically double-CSV your data. Export-CSV takes a collection of collections and outputs that to a CSV format - your data shouldn't be in a CSV format before calling the cmdlet. — alroc
– alroc, Commented Oct 3, 2013 at 12:57
you should pipe objects to export-csv, not comma separated strings. — Tekno Sal
– Tekno Sal, Commented Oct 3, 2013 at 16:16

Walter Mitty · Accepted Answer · 2013-10-03 14:37:11Z

1

Try

$ComputerObjects | Export-csv "results.csv"

If you want to take a quick peek at the results, you can try

Start results.csv

In my environment, this starts up Excel, and tells it to load the contents of the CSV file into a worksheet. YMMV.

edited Oct 3, 2013 at 14:37

answered Oct 3, 2013 at 13:33

Walter Mitty

19k2 gold badges32 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Powershell - Execute function and then export to CSV

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related