Community

how would one go about best deleting all characters after the @ sign in many lines of text containing email addresses?

thanks in advance,

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

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

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.

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