CODEWITHSUNDEEP
powershellimport-csvpowershell-5.1export-csvwhere-object
SeveredTRUTH
SeveredTRUTH

Reputation: 73

Delete Specific Rows from a CSV File Using PowerShell

The script that I put together does gather the results I need, but I was hoping to utilize a cleaner string.

After I gather all the needed information, I export the results to a csv file. There are three specific rows I would like to remove, so I re-import the csv file and delete those rows. This is the string I am currently utilizing:

#Remove Unneeded Users
import-csv .\LDAPCrossWalkTable.csv | Where-Object "User ID" -ne 'test' | Where-Object "User ID" -ne 'process' | Where-Object "User ID" -ne 'app' | export-csv .\LDAPCrossWalkTableFinal.csv -Force -NoTypeInformation

Is there a way to use the Where-Object cmdlet one time by using the -or operator rather than pipe 3 separate times? I just can't figure out the correct syntax. Any input it greatly appreciated! Thanks!

UPDATE: Thank you, Olaf, for the prompt response and multiple options! I decided to proceed with this string:

import-csv .\LDAPCrossWalkTable.csv | Where-Object {$_.'User ID' -notin 'test', 'process', 'app'} | export-csv .\LDAPCrossWalkTableFinal.csv -Force -NoTypeInformation

Upvotes: 1

Views: 873

Answers (1)

Olaf
Olaf

Reputation: 5252

Yes, there is a way to combine more than one filter in one Where-Object. And you can apply this filter before you export your results to a CSV file

Where-Object {
$_.'User ID' -ne 'test' -and
$_.'User ID' -ne 'process' -and 
$_.'User ID' -ne 'app'
}

As pointed out by the comment of @Santiago Squarzon ... and alternative to having multiple -ne would be to use -notin.

Where-Object {
    $_.'User ID' -notin 'test', 'process', 'app'
}

... or ... as suggested like this:

Where-Object 'User ID' -notin 'test', 'process', 'app'

A third way recommended by @Theo would be top use regex like this:

Where-Object 'User ID' -notmatch '\b(test|process|app)\b'

or like this if it should be a full match

Where-Object 'User ID' -notmatch '^(test|process|app)$'

Now you have plenty of options to choose from. ;-)

Upvotes: 4

Related Questions