Compare two lists, file1 and file2, get the IDs in file2 present in the usernames in file1

Tags:

Answer: 1

35 hours ago

Please I need help...

I have two lists, file1 and file2. The list file1 has only usernames, while file2 has the same usernames but with additional columns (username|private yes or no|id).

Basically I need to know the ID (which is in file2) of the usernames which are in file1.

file1 (50k lines):

user1
user2
user3

...

file2 (500k lines):

user1|YES|8125958
user2|YES|4825195
user3|YES|8757159
user4|NO|5185761

...

Popular Search

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 1 2 3 4 5 6 7 8 9