Community

I just extracted over 10K user accounts from our forum and it ended up in this format:

username user@email.com

How can I extract only the email address from this line? I tried bookmarking "@", but it picked up the username also. Any thoughts?

Search for: ^.+[[:blank:]]
Replace with: nothing


Using POSIX and RegEx on

Always have a backup available.

Hi Bob,

Thanks but it seemed to remove all the lines but one. The text file is listed with over 10K lines like this:

-------------------------------------
username1 email@email1.com
username2 email@email2.com
username3 email@email3.com
-------------------------------------

I want it to end up like this:

-------------------------------------
email@email1.com
email@email2.com
email@email3.com
-------------------------------------

Thanks!

Just took your last example.
I end up with this:

-------------------------------------
email@email1.com
email@email2.com
email@email3.com
-------------------------------------

Looks the same to me. What am I not seeing?

Turned on POSIX and now it removes everything (reg exp: on). Here are my setting:

Find What: ^.+[[:blank:]]
Replace with: nothing

.+ is greedy, so if there is a blank at the end of the line, it removes all.

use
^[^[:blank:]]+[[:blank:]]
instead, i.e. search for as many non-blanks as possible at the beginning of the line plus one blank after that.


If your user names can contain blanks, it gets more complicated:
^.*[[:blank:]]([^[:blank:]]+@)
replace by \1

Thanks MudGuard for pointing out the invisible spaces at the ends of the line.

I should have thought of that myself even though there was no mention of it in the samples.

Great, worked perfectly! Thanks guys

Ah, wrote too soon. It seems like there are many entries which still left the username in the line with a space after it. Is there a way to remove all extra spaces only at the end of the line? This way, I can weed them out and do a search for the username spaces after that.