Remove String in one text file from another text file

Question

I have two text files. One has all servers on the domain (servers_all.txt) and the other has only the virtual servers (virtual_servers.txt). I want to get the difference between the two so I can find the physical servers. I have been tring compare-object to no avail

Compare-Object (gc servers_all.txt) (gc .\VIRTUAL_SERVERS.TXT) -IncludeEqual

Is there a way I can remove the servers listed in virtual_servers.txt from servers_all.txt.

Both txt files are formatted the same way with only the server names in a single column ie:

ServerA
ServerB
ServerC

Bacon Bits · Accepted Answer · 2016-05-06 20:57:58Z

2

Compare-Object is somewhat obtuse (to put it mildly). I avoid it.

$VirtualServers = Get-Content .\VIRTUAL_SERVERS.TXT;
$NonVirtualServers = Get-Content servers_all.txt | Where-Object { $_ -notin $VirtualServers };

The only thing to beware of here is file formatting errors like leading or trailing whitespace. If you want to handle that, you could do something like:

$VirtualServers = Get-Content .\VIRTUAL_SERVERS.TXT | ForEach-Object { $_.Trim() };
$NonVirtualServers = Get-Content servers_all.txt | ForEach-Object { $_.Trim() } | Where-Object { $_ -notin $VirtualServers };

edited May 6, 2016 at 20:57

answered May 6, 2016 at 20:46

Bacon Bits

32.4k6 gold badges63 silver badges78 bronze badges

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

Comments

TessellatingHeckler · Accepted Answer · 2016-05-06 21:05:44Z

0

$all = 'a','b','c','d'
$virtual = 'b','c'

Compare-Object $all $virtual -PassThru

->

a
d

answered May 6, 2016 at 21:05

TessellatingHeckler

29.3k4 gold badges55 silver badges96 bronze badges

Collectives™ on Stack Overflow

Remove String in one text file from another text file

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related