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

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
shippee
Posts: 12
Joined: Fri Dec 26, 2008 9:40 pm
Location: Olympia, Washington
Contact:

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

Post 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,
shippee
Posts: 12
Joined: Fri Dec 26, 2008 9:40 pm
Location: Olympia, Washington
Contact:

here is a sampling of the lines

Post 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
ben_josephs
Posts: 2461
Joined: Sun Mar 02, 2003 9:22 pm

Post 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
shippee
Posts: 12
Joined: Fri Dec 26, 2008 9:40 pm
Location: Olympia, Washington
Contact:

content deletion

Post 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.
ben_josephs
Posts: 2461
Joined: Sun Mar 02, 2003 9:22 pm

Post 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
Post Reply