Find & Replace
- Started
- Last post
- 6 Responses
- -kappa-
I've got a massive text file with emails in it...
I want to go through and delete everything before the @ symbol leaving only the domains.Using Texpad...
Any know their Regular Expressions?Eg:
to become
@mail.com
- flavorful0
I haven't done this in a long time, but I could do this with SQL before and mapped it over to Excel.
I got it open and am trying some things out, I'll let you know what I come up with.
You're not going to be able to do this with TextPad, but if each e-mail address is on its own line then you can just copy and paste into Excel.
Actually ... if you do a find & replace for the "@" symbol and replace it with a carriage return and the "@" symbol again that will break all the domains to their own line.
Then maybe you can wipe out every line with an "@" symbol somehow?
Shrug.
- flavorful0
Actually I got it in Excel. Check your mail in a second buddy.
- flavorful0
Mail! :D
- -kappa-0
Thanks man...Your a gun.
- fugged0
search for: .+@
replace with @
- -kappa-0
That also did it...Thanks fugged!
It's funny I was trying .*@