How do you do this?
 

I have 2 text files on a windows machine.

Lets call the first one "A"
Lets call the second one "B"

A is just a list of usernames that dont work
B is a master list of usernames

I need to write a new file, lets call it "C"

C needs to be a list of usernames that do work

So, if a username in "A" matches a username in "B", remove it
Output the good list to "C"

Complicated way to explain a simple process.

Anybody know an app that does it?

On a *nix machine (linux/mac) you could use COMM

I am pretty sure UltraEdit can be configured to do this.

EDIT: http://www.ultraedit.com/downloads/u..._download.html

Fully functional trial download. Give it a shot

If you can copy both (sorted) files to a server and can use the command line, this should give you the info you want.

comm -13 broken.txt master.txt > working.txt

if you need to sort the files on the server side do this first
sort broken.txt -o broken.txt
sort master.txt -o master.txt

I have ultraedit but I've never seen how it can do this.

Windows equivalent commands according to this are COMP and FC. Maybe that'll help.
http://ss64.com/bash/comm.html

Thanks I'll try this out

Hey are you sure thats correct?

Cause now its like, they are almost all bad accounts.

Jesus christ half my traffic died.

findstr /G:A.txt /V B.txt > clean.txt

try that.

(untested....)

edit: tested

Should be right. I just created some test files:

broken.txt (sorted)
------------
brujah

master.txt (sorted)
-------------
brujah
edgar
mrpheer

comm -13 broken.txt master.txt:
edgar
mrpheer

Hmmm maybe its something else then

anyway, the list is smaller so thats good

import in excel and sort

In UltraEdit.
Open both files
File>Sort>Advanced Sort Options

From the Dialog
tick Merge Sort Results
tick Remove Duplicates

That should do it.