Collection to CSV output

Question

Is there a nice way to convert Collection<PSObject> to CSV output?

Collection<PSObject> psResult = pipeline.Invoke();

Tried pipeline.ToCsv(); Also psResult.ToCsv()

Any ideas?

I think there is no way out of serializing your PSObjects. Adding an overload to ToString() to the class and separating each field with a comma (you could use reflection to avoid adding each field manually) is an option. — Veverke, Jun 27 '16 at 09:14
Why not add an `Export-Csv` cmdlet to the `pipeline` instead? — Mathias R. Jessen, Jun 27 '16 at 09:47

score 1 · Accepted Answer · answered Jun 27 '16 at 11:58

1

Add the ConvertTo-Csv cmdlet to your pipeline.

The Collection<PSObject> returned will consist of comma-separated strings, easily converted to IEnumerable<string> or string[]

answered Jun 27 '16 at 11:58

Mathias R. Jessen

1 Answers1