$results | export-csv testout.csv -NoTypeInformation Will get rid of the #Type stuff.
Thanks Webster > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Brown, Ken F. > Sent: Friday, May 29, 2015 9:29 AM > To: [email protected] > Subject: [powershell] Hashing Question > > I put together this script as a test so I can take random input, format it > for a > CSV file and then export the CSV. (I'm planning to have 10-15 input fields, > but for a test, this works). > > I used to use an Excel COM method to do this - which works for large > datasets - but requires Excel to be installed. When running on servers, > people don't really like having to install Excel (which I agree) - hence this > method. > > My question is...will the columns ever become misaligned when the "hash" > below is created and when it is added to the 'results'? > > I.e. in this example, will the 'name' and 'phone' columns ever get swapped? > Using excel method, I know it won't as I force the data into specific columns > (using numbers, not names) > > Also, not sure why the #TYPE line is added to the output...but an import-csv > of the file ignores it. > > Thanks > > P.S. I'm doing this to get lots of data (15 -20 columns) from mailboxes and > will > use for other stuff now, also > > > PS C:\temp\Powershell> type .\testinp.csv The input file > Name,phone,state > Joe,5551212,confusion > Happy,1234567,excited > Tired,5552121,sleepy > > > PS C:\temp\Powershell> .\testexp.ps1 Executing the > script > > PS C:\temp\Powershell> type .\testexp.ps1 The script > $list=import-csv testinp.csv > > $results=@() > > foreach ($i in $list) { > $hash=@{} > $hash.name=$i.name > $hash.phone=$i.phone > $hash.state=$i.state > > $newrecord=new-object psobject -property $hash > > $results+=$newrecord > } > > $results | export-csv testout.csv > > > > PS C:\temp\Powershell> type .\testout.csv The output > file > #TYPE System.Management.Automation.PSCustomObject > "name","phone","state" > "Joe","5551212","confusion" > "Happy","1234567","excited" > "Tired","5552121","sleepy" > > > > ================================================ > Did you know you can also post and find answers on PowerShell in the > forums? > http://www.myitforum.com/forums/default.asp?catApp=1 ================================================ Did you know you can also post and find answers on PowerShell in the forums? http://www.myitforum.com/forums/default.asp?catApp=1
