![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | 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 Specs![]() |
| | #2 (permalink) |
| | 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 Specs![]() |
| | #3 (permalink) |
| | Re: export-csv question That worked, thanks for the help! |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Get-acl and export-csv | PowerShell | |||
| using export-csv to export to multiple CSV files | PowerShell | |||
| Export to WAB? | Vista mail | |||
| export-clixml and compare-object question | PowerShell | |||
| Export-CliXml/Export-Csv: Change to Export-Object? | PowerShell | |||