How do you do this? - GoFuckYourself.com

Mr Pheer · 03-17-2012, 02:35 PM

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?

Brujah · 03-17-2012, 02:40 PM

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

Harmon · 03-17-2012, 02:40 PM

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

Brujah · 03-17-2012, 02:47 PM

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

Mr Pheer · 03-17-2012, 02:48 PM

Quote:

Originally Posted by Harmon

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

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

Brujah · 03-17-2012, 02:49 PM

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

Mr Pheer · 03-17-2012, 02:53 PM

Quote:

Originally Posted by Brujah

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

Mr Pheer · 03-17-2012, 06:52 PM

Quote:

Originally Posted by Brujah

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

Hey are you sure thats correct?

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

Jesus christ half my traffic died.

u-Bob · 03-17-2012, 07:31 PM

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

try that.

(untested....)

edit: tested

Brujah · 03-17-2012, 07:42 PM

Quote:

Originally Posted by Mr Pheer

Hey are you sure thats correct?

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

Jesus christ half my traffic died.

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

Mr Pheer · 03-17-2012, 10:23 PM

Hmmm maybe its something else then

anyway, the list is smaller so thats good

grumpy · 03-18-2012, 02:21 AM

import in excel and sort

Dvae · 03-18-2012, 04:39 AM

Quote:

Originally Posted by Mr Pheer

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

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

From the Dialog
tick Merge Sort Results
tick Remove Duplicates

That should do it.

03-17-2012, 02:35 PM	#1
Mr Pheer Retired Industry Role: Join Date: Dec 2002 Posts: 20,984	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? __________________ Get your booster! It's safe

03-17-2012, 02:40 PM	#2
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	On a nix machine (linux/mac) you could use COMM __________________ Free Premium Domain Lists and Tools at Clickmojo.com* For Sale: Obscenity.com

03-17-2012, 02:40 PM	#3
Harmon ( ͡ʘ╭͜ʖ╮͡ʘ) Industry Role: Join Date: Mar 2004 Posts: 20,007	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 Last edited by Harmon; 03-17-2012 at 02:41 PM..

03-17-2012, 02:47 PM	#4
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	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 __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

03-17-2012, 02:49 PM	#6
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	Windows equivalent commands according to this are COMP and FC. Maybe that'll help. http://ss64.com/bash/comm.html __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

03-17-2012, 07:31 PM	#9
u-Bob there's no $$$ in porn Industry Role: Join Date: Jul 2005 Location: icq: 195./568.-230 (btw: not getting offline msgs) Posts: 33,063	findstr /G:A.txt /V B.txt > clean.txt try that. (untested....) edit: tested Last edited by u-Bob; 03-17-2012 at 07:34 PM..

03-17-2012, 10:23 PM	#11
Mr Pheer Retired Industry Role: Join Date: Dec 2002 Posts: 20,984	Hmmm maybe its something else then anyway, the list is smaller so thats good __________________ Get your booster! It's safe

03-18-2012, 02:21 AM	#12
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	import in excel and sort __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888