How can I filter out empty printer columns from my CSV?

If you want to exclude any row with empty printer values, you could modify your command like this:

`Import-Csv -Path "$PSScriptRootRooms.csv" | Where-Object {$_.ROOM -like "*$DeviceName*" -and ($_.PRINTER01 -ne '' -or $_.PRINTER02 -ne '')}` This checks if at least one printer has value before including the row.

Here's a quick two-liner that might help:

```PowerShell
$Room = Import-Csv -Path "$PSScriptRootRooms.csv" | Where-Object {$_.ROOM -like "*$DeviceName*"}
@($Room.'PRINTER01', $Room.'PRINTER02').Where{$_}
``` This grabs the relevant room and then filters out any empty printer values from the output.

You might have to use a loop to filter out specific columns that have data. The way you’re set up, the command will show all columns regardless of the content, so creating a custom output might be necessary. Here's a simple loop you could try:

```PowerShell
$deviceName = "LAB01"
$rooms = Import-Csv C:usersPublictest.csv
foreach ($room in $rooms) {
if ($room.ROOM -like "$deviceName*") {
$room | Where-Object { $_.PRINTER01 -or $_.PRINTER02 }
}
}
``` This will iterate through and return only the rows with data in either printer column.