WatchGuard's newest access point includes an 802.11ac Wave 2 chipset, providing the fastest speeds for VoIP, video and music streaming, and large data file transfers. Additionally, enjoy the benefits of strong security as the 3rd radio delivers dedicated WIPS protection!
Solved
Import-CSV and remove specified values
Posted on 2016-08-18
I have a powershell script to export some account info from AD. I want to read this CSV file in and remove certain accounts. I can't do it dynamically as it's something a manager needs to specify. The CSV file output is below
"Email","FirstName","LastN
"User1@domain.com","UserF1
"User2@domain.com","UserF2
"User3@domain.com","UserF3
"User4@domain.com","UserF4
I'd like to be able to loop through a where clause and remove lines based on "Email address" I specify in the file. I forsee the need to add additonal accounts in the future so if I could use an array of some sort that would be best. I see a couple solutions online but not quite what I need. logic would be
Import CSV
If account is in the list below, remove the line from the CSV
"User1@domain.com"
"User4@domain.com"
"User9@domain.com"
"User10@domain.com"
Export-CSV Contents
any help is appreciated!
"Email","FirstName","LastN
"User1@domain.com","UserF1
"User2@domain.com","UserF2
"User3@domain.com","UserF3
"User4@domain.com","UserF4
I'd like to be able to loop through a where clause and remove lines based on "Email address" I specify in the file. I forsee the need to add additonal accounts in the future so if I could use an array of some sort that would be best. I see a couple solutions online but not quite what I need. logic would be
Import CSV
If account is in the list below, remove the line from the CSV
"User1@domain.com"
"User4@domain.com"
"User9@domain.com"
"User10@domain.com"
Export-CSV Contents
any help is appreciated!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
Active today
$ignore = @"
User1@domain.com
User4@domain.com
User9@domain.com
User10@domain.com
"@ -split "`r`n"
(Get-Content file.txt | Select-String -NotMatch -SimpleMatch $ignore) | Out-File file2.txt
Active 7 days ago
Sorry for the delay, I was on vacation. I tried to add this statement but it's not removing the line from the CSV file. it's just outputing the same exact text file it read back in.
Active today
There seems to be an EE issue with the backtick used, I suspect. Let's try something slightly different:
$ignore = 'User1@domain.com',
'User4@domain.com',
'User9@domain.com',
'User10@domain.com'
(Get-Content file.txt | Select-String -NotMatch -SimpleMatch $ignore) | Out-File file2.txt
Active 7 days ago
]Thank you for the help again. So this time the user was removed but the CSV file structure was manipulated in a way that makes it unusable. For some reason records are now traversing multiple lines in the CSV file.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Previously, on our Nano Server Deployment series, we've created a new nano server image and deployed it on a physical server in part 2. Now we will go through configuration.
- Veeam
- Powershell
- Hyper-V
- Windows Server 2016
- Azure
- Windows 10, Windows, *Nano Server
Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed.
Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month10 days, 13 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.