Wrap text in file on ubuntu

Question

I have 2 text files

$ cat com.txt
user1@myskype.com
user3@myskype.net
user5@myskype.net
user4@myskype.net
user2@myskype.net

$ cat net.txt
user1@myskype.net
user3@myskype.net
user5@myskype.net
user2@myskype.net
user4@myskype.net

now i would like to read 2 text files and wrap the matching username in format like

user1@myskype.net : user1@myskype.com

Thanks

What is your question? – Code-Apprentice Feb 07 '13 at 23:44 — Code-Apprentice, Feb 07 '13 at 23:44

score 4 · Accepted Answer · answered Feb 07 '13 at 23:47

4

try this one-liner:

awk -F'@' 'NR==FNR{a[$1]=$0;next}$1 in a{print a[$1]" : "$0}' net.txt com.txt

answered Feb 07 '13 at 23:47

Kent

189,393
32
233
301

@KevinNguyen: I deleted my answer because it's no longer appropriate because the two 'real' files don't have the same number of users in them. What would you like to happen when the usernames don't match up? – Steve Feb 08 '13 at 00:22
@KevinNguyen the pastebin link I cannot open... can you paste it in your question? – Kent Feb 08 '13 at 00:42
@Kent Can you check it back? Thanks! – Kevin Nguyen Feb 08 '13 at 07:10
@steve IF the username don't match, then we do nothing. I just want the matching ones. – Kevin Nguyen Feb 08 '13 at 07:11
@Kent Nevermind. Thank you so much for your awesome awk command. It works for me. Cheers – Kevin Nguyen Feb 08 '13 at 08:13

Wrap text in file on ubuntu

1 Answers1