Modifying CSV content with Powershell

Question

I have a CSV file, Devices.csv, containing IP Address, DeviceName, SerialNumber, MAC Address, UserName.

The Users column in all the rows of Devices.csv is prepopulated with a value [Unknown]

The code...

{Import-CSV Devices.csv | Where-Object {$_.IPAddress -eq '192.168.2.124'} | Select-Object -last 1 | FT  IPAddress, devicveName, SerialNumber,  MACAddress, User -AutoSize }

....outputs

IPAddress     deviceName     SNumber     MACAddress   User
---------     -----          -------     ----------   ----
192.168.2.124 ComputerA      1ABCDEFG    00xxYYbbCCdd [Unknown]

I want to be able to replace the [Unknown] text with a Username I have retrieved from a different source. Can I update just the User column on this line in Devices.csv using powershell and keep the rest of the CSV file intact ?

Thanks, Brian

Shay Levy · Accepted Answer · 2013-12-09 13:08:51Z

1

$csv = Import-CSV Devices.csv
$csv | Where-Object {$_.IPAddress -eq '192.168.2.124'} | Select-Object -Last 1 | ForEach-Object {$_.User = $user}
$csv | Export-Csv Devices.csv -NoTypeInformation

answered Dec 9, 2013 at 13:08

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

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

1 Comment

user3082478 Over a year ago

Shay, Exactly what I wanted, Thanks Brian

Ansgar Wiechers · Accepted Answer · 2013-12-09 12:34:59Z

1

Try this:

$otheruser = '...'

Import-Csv Devides.csv | % {
  if ($_.User -eq '[Unknown]') { $_.User = $otheruser }
  $_
} | Export-Csv Divices_modified.csv -NoTypeInformation

answered Dec 9, 2013 at 12:34

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Collectives™ on Stack Overflow

Modifying CSV content with Powershell

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related