Array to CSV, not the right format

Question

I used the ">" operator to put the content of an array into a CSV file, here is what i got, the first line is empty

Computer                                                    IP                                                         
--------                                                    --                                                         
IMPPRD1                                                     172.22.30.33                                               
IMPPRD2                                                     172.22.30.31                                               
IMPPRD3                                                     172.22.30.32                                               
IMPSR1                                                      172.22.30.12                                               
IMPPRD5                                                     172.22.30.17

I would like it to be a normal CSV, so something like this :

Computer,IP                                                                                                        
IMPPRD1,172.22.30.33                                               
IMPPRD2,172.22.30.31                                               
IMPPRD3,172.22.30.32                                               
IMPSR1,172.22.30.12

How could I manage to do this using powershell? Thanks !

Yeaaaah, I already tried it but I didn't think of putting the pipe, haha, nice, thanks alot — Sami
– Sami, Commented May 18, 2015 at 17:19

Benjamin Hubbard · Accepted Answer · 2015-05-18 17:49:14Z

2

Using > outputs as normal text - including the spaces between columns. Basically the same as Write-Output. You are looking for Export-Csv which outputs in CSV format.

answered May 18, 2015 at 17:49

Benjamin Hubbard

2,92524 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Array to CSV, not the right format

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related