Windows Vista Forums
Vista Forums Home Join Vista Forums Webcasts Windows 7 Forum Vista Tutorials Tags

Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Microsoft Technical Newsgroups > PowerShell

export-csv question

Update your Vista Drivers Update Your Drivers Now!!
Closed Thread
 
Thread Tools Display Modes
Old 10-10-2007   #1 (permalink)
blayne
Guest


 

export-csv question

I am trying to convert a list of IP addresses to a new csv file that has the
host name and ip address in it. I can get the dns name into the csv file but
not the ip address. Here is my code so far;

get-content "C:\ListOfIPs.txt" |
% { [System.Net.Dns]::GetHostByAddress($_) } |
Sort-Object HostName |
Select-Object HostName |
Export-Csv c:\HostNameIPAddress.csv

How do I add another column with the IP address next to the host name into
the destination file?

Thanks

My System SpecsSystem Spec
Old 10-10-2007   #2 (permalink)
Kiron
Guest


 

Re: export-csv question

Use a calculated property:

get-content c:\ListOfIPs.txt |
% { [System.Net.Dns]::GetHostByAddress($_) } |
Sort-Object HostName | Select-Object HostName,
@{name = 'IP Address';
expression = {"$($_.AddressList)"}} |
Export-Csv c:\HostNameIPAddress.csv -noType

--
Kiron
My System SpecsSystem Spec
Old 10-10-2007   #3 (permalink)
blayne
Guest


 

Re: export-csv question

That worked, thanks for the help!
My System SpecsSystem Spec
Closed Thread

Thread Tools
Display Modes



Similar Threads
Thread Thread Starter Forum Replies Last Post
using export-csv to export to multiple CSV files Srinivas PowerShell 4 05-23-2008 02:46 PM
Export to WAB? FiOS Dave Vista mail 4 08-22-2007 09:58 PM
how to export newsgroups Robert James Vista General 1 08-22-2007 06:02 PM
export-clixml and compare-object question Gaurhoth PowerShell 1 12-21-2006 03:19 PM
Export-CliXml/Export-Csv: Change to Export-Object? Alex K. Angelopoulos [MVP] PowerShell 3 06-04-2006 07:57 PM


Vistax64.com is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media 2005-2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51