Hello,

I have a large number of email addresses that I would like to cut down to the domain. For example:

blah@microsoft.com
12345@yahoo.com
webmaster@google.com

What I want to know is, is there a command that will go through the entire list (over 1000 lines) and delete all characters before the @ symbol? Since they are of different lengths, I can't do a simple search and delete/replace. Anyways, I don't know if it's possible, but if it is, I imagine this would be the place for the answer. Google didn't provide me with a definitive answer, so I thought I'd check here. Thank you in advance!

Scine

:%s/^.*\@//

Tried that one, but I get

E62: Nested \@
E476: Invalid command.

Odd. Tried swapping / for \ and vice versa as well as a few other variant ideas. Ideas? By the way, thanks for the quick reply!

Scine

Are you using vi or vim? Vim might have a magic setting, in which case you don’t need to escape the @ at all just plain:
P.S. what’s Scine?

I'm using vi. I tried your code, and it did work somewhat. It brought my email list from blah@microsoft.com to microsoft.com. However, I found a bit of tinkering with your code and got it to work. I used this and it worked perfectly.

%s/^.*[@]/*@/

The above code made blah@microsoft.com to *@microsoft.com

Thank you very much for all your help.

P.S. Scine is a nickname I've had for a good long while. Force of habit when signing my name I guess. Thanks again!

Scine

Should work, but the actual command is:

sed -i s/^.*\@//g yourfile.txt

jlinkels

Thank you very much for the info! Although I must admit, my "sed" abilities aren't where I'd like them to be. I've been running linux for the better part of a few years now, and I'm comfortable with many aspects of it, I must admit that I'm not too familiar with some more popular parts such as sed and awk. But I did notice this particular bit of knowledge helped me out in another area of my project. Thank you very much!

Scine

Oops, I must have misread the OP. I thought this is what you wanted.

No problem at all. I appreciate all your help! Thanks again!

Scine

As a side note, to do the opposite, that is to delete everything past a certain character, I used %s/com./com That would replace blah@microsoft.com=username@#$@#$ with blah@microsoft.com It was a part of a project I'm working on, but thought I would mention it to help other people out.

Scine