List Matcher / File Parser

Cyclone

Active member
Trusted
Contributor
Retired Moderator
Feedback: 3 / 0 / 0
Joined
Dec 30, 2019
Messages
3,175
Reaction score
900
Credits
5,898
Two new features have been added to https://hashes.com, List Matcher & File Parser.

List Matcher:
https://hashes.com/en/listmatcher

List Matcher instructions. This feature allows you to parse your files to match hash:info + item:hash = item:info.

1. Select the file containing hash:info, then press Submit

2a. Under "Split", type in the delimiter / symbol used to separate hash:info -- usually colon :

2b. Under "Join", type in the delimiter / symbol you wish to separate hash:info in output -- usually colon :

3. Select the Column containing your hashes

4. Select the file containing the rest of the data (item:hash)

5. Preview the lines of the file you just uploaded and confirm the delimiter / symbol -- usually colon :

6. Select the Column containing your hashes

7. Choose which columns to include in your output file (info)

8. Choose which columns to include in your output file (item)

9. Choose the order that the columns will be in. ex: column 1 is left side and column 2 is right side

10. View the sample of your data. If everything looks good, press Submit. This will take you back to List Matcher and your data will be 'Queued' at the bottom under the label: "Files".


If you did not complete the configuration, your files will be listed with status "Configuration required".

Once matching is complete, status will change to "Completed" and you may download the parsed file.

You may also select "Change Output Format" to reconfigure the List Manager settings.

File Parser:
https://hashes.com/en/fileparser

File Parser instructions. This feature allows you to parse your large databases into only the items you need.

Example: Convert a file containing:

John:Smith:555-555-5555:test@example.com:55502f40dc8b7c769880b10874abc9d0

to a file containing:

John,Smith,test@example.com

1. Select the file containing your database, then press Submit

2a. Under "Split", type in the delimiter / symbol used to separate the database entries

2b. Under "Join", type in the delimiter / symbol you wish to separate the database entries output

2c. Optional: Skip and ignore this # of lines will skip the first nth lines of your database, useful if there is a header you don't wish to include

2d. Optional: if your entries are enclosed with a delimiter, ex: 'entry 1','entry 2', you may include the delimiter here for removal

3. Choose which columns to include in your output file (only select the columns you need)

4. Choose the order that the columns will be in. ex: column 1 is left side and column 2 is right side

5. View the sample of your data. If everything looks good, press Submit. This will take you back to List Matcher and your data will be 'Queued' at the bottom under the label: "Files".

If you did not complete the configuration, your files will be listed with status "Configuration required".

Once matching is complete, status will change to "Completed" and you may download the parsed file.

You may also select "Change Output Format" to reconfigure the File Parser settings.

[updated 11-18-2020]
 
Last edited:

neme

Member
Feedback: 0 / 0 / 0
Joined
Apr 7, 2021
Messages
10
Reaction score
1
Credits
97
hello,

Thank you for the tutorial.
I feel like complete idiot... I've been looking on the whole internet how to quickly and succesfully match two lists in windows (batch/excel/python script) and I just can't find it.


file1.txt is:
user:hash

file2.txt is:
hash:password

result_file.txt that I want to get is:
user:password

- Note that not all hashes from file1.txt are in file2.txt
- hash duplicates in file2.txt might be removed but they still occur few times in file1.txt

thank you for any help ...
 

neme

Member
Feedback: 0 / 0 / 0
Joined
Apr 7, 2021
Messages
10
Reaction score
1
Credits
97
s
hello,

Thank you for the tutorial.
I feel like complete idiot... I've been looking on the whole internet how to quickly and succesfully match two lists in windows (batch/excel/python script) and I just can't find it.


file1.txt is:
user:hash

file2.txt is:
hash:password

result_file.txt that I want to get is:
user:password

- Note that not all hashes from file1.txt are in file2.txt
- hash duplicates in file2.txt might be removed but they still occur few times in file1.txt

thank you for any help ...
(can't edit my previous post) Now I remember I've asked this before but it got deleted. I actually don't see anything "illegal" by asking about text files manipulation or learning excel :unsure: I might ask on stackoverflow for script but thought this might be more accurate place for this question
 
Top