Page 1 of 1

how to best delete everything after @ in many lines of email

Posted: Sat Jun 25, 2011 11:20 pm
by shippee
how would one go about best deleting all characters after the @ sign in many lines of text containing email addresses?

thanks in advance,

here is a sampling of the lines

Posted: Sat Jun 25, 2011 11:23 pm
by shippee
1st.vice.president@wfselo... N/A No Yes 100 MB 3% FiltersPassword
2nd.vice.president@wfselo... N/A No Yes 100 MB 1% FiltersPassword
agency.rep.biia@wfselocal... N/A No Yes 100 MB 0% FiltersPassword
agency.rep.dis@wfselocal4... N/A No Yes 100 MB 0% FiltersPassword
agency.rep.dnr@wfselocal4... N/A No Yes 100 MB 0% FiltersPassword
agency.rep.dol@wfselocal4... N/A No Yes 100 MB 5% FiltersPassword
agency.rep.drs@wfselocal4... N/A No Yes 100 MB 0% FiltersPassword
agency.rep.dshs@wfselocal... N/A No Yes 100 MB 3% FiltersPassword
agency.rep.ecy@wfselocal4... N/A No Yes 100 MB 0% FiltersPassword
agency.rep.spscc@wfseloca... N/A No Yes 100 MB 2% FiltersPassword
agency.rep.wsp@wfselocal4... N/A No Yes 100 MB 2% FiltersPassword
backup@wfselocal443.org N/A No Yes 100 MB 6% FiltersPassword
cardcommittee@wfselocal44... N/A No Yes 100 MB 1% FiltersPassword
communication.chair@wfsel... N/A No Yes 100 MB 0% FiltersPassword
diversity.committee@wfsel... N/A No Yes 100 MB 0% FiltersPassword
facebook@wfselocal443.org N/A No Yes 100 MB 2% FiltersPassword
facebook1@wfselocal443.org N/A No Yes 100 MB 0% FiltersPassword
general@wfselocal443.org N/A Yes Yes 100 MB 2% FiltersPassword
grievance.committee@wfsel... N/A No Yes 100 MB 0% FiltersPassword
member.at.large.1@wfseloc... N/A No Yes 100 MB 9% FiltersPassword
member.at.large.2@wfseloc... N/A No Yes 100 MB 2% FiltersPassword
member.at.large.3@wfseloc... N/A No Yes 100 MB 2% FiltersPassword
newsletter@wfselocal443.org N/A No Yes 100 MB 5% FiltersPassword
officemanager@wfselocal44... N/A No Yes 100 MB 4% FiltersPassword
organizing.chair@wfseloca... N/A No Yes 100 MB 3% FiltersPassword
political.action.chair@wf... N/A No Yes 100 MB 0% FiltersPassword
postmaster@wfselocal443.org N/A N/A N/A 100 MB 4% FiltersPassword
president@wfselocal443.org N/A No Yes 100 MB 23% FiltersPassword
scholarship@wfselocal443.... N/A No Yes 100 MB 5% FiltersPassword

Posted: Sun Jun 26, 2011 8:35 am
by ben_josephs
Find what: @.*
Replace with: @

[X] Regular expression

Replace All
Do you really want to delete the "@" sign and all characters after it?
Find what: @.*
Replace with: [nothing]

[X] Regular expression

Replace All

content deletion

Posted: Sat Jul 02, 2011 3:24 pm
by shippee
Yes, ben_josephs, I did want to delete everything after the "@" to end up with a short 'email alias' listing, and had I needed to add it all back it would have been easy to merely do a search and replace with regular expressions along the lines of
search:
replace: $@wfselocal443.org
correct?

Thank you for all of your activity in this forum - I am able to learn much from your postings.

Posted: Wed Jul 06, 2011 3:56 pm
by ben_josephs
I think you mean you want to delete the "@" sign and all characters after it.

And I think you mean
Find what: $
Replace with: @wfselocal443.org

[X] Regular expression

Replace All