NOTE: When cracking WPA/WPA2 passwords, make sure you check gpuhash.me first incase it's already been processed.

Home - General Discussion - How to sort the database by keys?


6 Results - Page 1 of 1 -
1
Author Message
Avatar
alektrick

Status: n/a
Joined: Mon, 06 Aug 2018
Posts: 6
Team:
Reputation: 2 Reputation
Offline
Sat, 01 Dec 2018 @ 21:43:31

Hello
There are 2 files.
1 file:
.txt weighs 600 gigabytes
there are lines of the form (mail:pass)
testmail@mail.com: 12345678
qwergty@hotmail.com: 123fdfgd112
0chgdvcewbc@aol.com: fggj34438hg8
.........

2 file:
200,000 lines of sight (mail)
qwergty@hotmail.com
2352355235@aol.com
...........

It is necessary from 1 file to pull out all the lines where, there is a match list of emails in 2 file

How to do it?


Avatar
freeroute
Moderator
Status: Trusted
Joined: Sat, 16 Jul 2016
Posts: 2327
Team:
Reputation: 7872 Reputation
Online
Sat, 01 Dec 2018 @ 23:16:37

Command: "cat file1.txt "

testmail@mail.com:12345678
qwergty@hotmail.com:123fdfgd112
0chgdvcewbc@aol.com:fggj34438hg8
testmail1@gmail.com:qwerty
newmail@co.uk:23456

Command: "cat file2.txt "

qwergty@hotmail.com
2352355235@aol.com
testmail1@gmail.com
newmail@co.uk

Emails can be found in the file1.txt only:
comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
0chgdvcewbc@aol.com
testmail@mail.com

Emails can be found in the file2.txt only:
comm -1 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
2352355235@aol.com

Emails can be found in both file:
comm -1 -2 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
newmail@co.uk
qwergty@hotmail.com
testmail1@gmail.com


If I helped a +rep is appreciated!

: 13hDMK85KhVnPb2eTFBacHD6kDjKYFLudb
XMPP: freeroute@xmpp.jp

Avatar
alektrick

Status: n/a
Joined: Mon, 06 Aug 2018
Posts: 6
Team:
Reputation: 2 Reputation
Offline
Sun, 02 Dec 2018 @ 00:17:33

freeroute said:

Command: "cat file1.txt "

testmail@mail.com:12345678
qwergty@hotmail.com:123fdfgd112
0chgdvcewbc@aol.com:fggj34438hg8
testmail1@gmail.com:qwerty
newmail@co.uk:23456

Command: "cat file2.txt "

qwergty@hotmail.com
2352355235@aol.com
testmail1@gmail.com
newmail@co.uk

Emails can be found in the file1.txt only:
comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
0chgdvcewbc@aol.com
testmail@mail.com

Emails can be found in the file2.txt only:
comm -1 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
2352355235@aol.com

Emails can be found in both file:
comm -1 -2 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
newmail@co.uk
qwergty@hotmail.com
testmail1@gmail.com

How to get the entire line with a password?


Avatar
alektrick

Status: n/a
Joined: Mon, 06 Aug 2018
Posts: 6
Team:
Reputation: 2 Reputation
Offline
Sun, 02 Dec 2018 @ 01:10:58

freeroute said:

Command: "cat file1.txt "

testmail@mail.com:12345678
qwergty@hotmail.com:123fdfgd112
0chgdvcewbc@aol.com:fggj34438hg8
testmail1@gmail.com:qwerty
newmail@co.uk:23456

Command: "cat file2.txt "

qwergty@hotmail.com
2352355235@aol.com
testmail1@gmail.com
newmail@co.uk

Emails can be found in the file1.txt only:
comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
0chgdvcewbc@aol.com
testmail@mail.com

Emails can be found in the file2.txt only:
comm -1 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
2352355235@aol.com

Emails can be found in both file:
comm -1 -2 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
newmail@co.uk
qwergty@hotmail.com
testmail1@gmail.com


I apologize in advance for my English =)
There is 1.txt
Contains mail: pass

There is 2.txt
Contains mail. No password.

I want to compare 2.txt with 1.txt.

If in 1.txt there is a match in the mail list from 2.txt.

Then I need to output the entire mail: pass string from 1.txt


Avatar
alektrick

Status: n/a
Joined: Mon, 06 Aug 2018
Posts: 6
Team:
Reputation: 2 Reputation
Offline
Sun, 02 Dec 2018 @ 01:11:38

freeroute said:

Command: "cat file1.txt "

testmail@mail.com:12345678
qwergty@hotmail.com:123fdfgd112
0chgdvcewbc@aol.com:fggj34438hg8
testmail1@gmail.com:qwerty
newmail@co.uk:23456

Command: "cat file2.txt "

qwergty@hotmail.com
2352355235@aol.com
testmail1@gmail.com
newmail@co.uk

Emails can be found in the file1.txt only:
comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
0chgdvcewbc@aol.com
testmail@mail.com

Emails can be found in the file2.txt only:
comm -1 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
2352355235@aol.com

Emails can be found in both file:
comm -1 -2 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
newmail@co.uk
qwergty@hotmail.com
testmail1@gmail.com


I apologize in advance for my English
There is 1.txt
Contains mail:pass

There is 2.txt
Contains mail. No password.

I want to compare 2.txt with 1.txt.

If in 1.txt there is a match in the mail list from 2.txt.

Then I need to output the entire mail:pass string from 1.txt


Avatar
freeroute
Moderator
Status: Trusted
Joined: Sat, 16 Jul 2016
Posts: 2327
Team:
Reputation: 7872 Reputation
Online
Sun, 02 Dec 2018 @ 06:49:03

Command: "comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt ) | grep -vf- file1.txt"

Output:
qwergty@hotmail.com:123fdfgd112
testmail1@gmail.com:qwerty
newmail@co.uk:23456


If I helped a +rep is appreciated!

: 13hDMK85KhVnPb2eTFBacHD6kDjKYFLudb
XMPP: freeroute@xmpp.jp


6 Results - Page 1 of 1 -
1

We have a total of 163298 messages in 20501 topics.
We have a total of 19268 registered users.
Our newest registered member is pikapika.