Community

Perfect! Thanks so much for your help

Hi Everyone,

I have a large database of email addresses in a text file but many of the entries have the full name of the person. I'm trying to find a command in TextPad to do the following:

--------------------------------------
FROM THIS:
John Smith <name1@email.com>
Jane Smith <name2@email.com ...

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.

Great, worked perfectly! Thanks guys

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

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

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 ...

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?

Hello,

I'm trying to import a mailing list of 20K entries into a new program and I receive this error when importing my csv file:

warning: Read wrong fields number count: '3' expected 2

Since I only have 2 fields in the list (email/name), I'm assuming that some of my entries have more than 1 ...

Hello Everyone.

I need to figure out how to remove everything from a file while keeping only the email addresses. For example, my original file looks like this:

----------------------
test test test email@email.com blah blah
blah blah blah blah blah blah blah blah
blah blah blah blah test@test ...

ben_josephs-

Pefect. Thanks again for all your help.

ben_josephs-

Thanks for all your help on the past questions. I have two more quick questions for you. I need to figure out a way to take entries on my newsletter list like this:


email@email.com,John
email2@email2.com,Mike
email3@email3.com,Steve


The end result willl remove the first names and ...

ben_josephs-

Great, thanks for all your help! I really appreciate it.

ben_josephs-

Perfect! You saved me a ton of time.

However, I just ran into a small issue. I have have my list of email addresses and when I sort them for duplicates, I can't see which emails are being removed in TextPad. So, I take the file and run it in SSH with this Unix command:


uniq -d ...

ben_josephs-

Awesome! Works perfectly. My last concern is how to setup the file, so the end result looks like this:

Before:


email1@email1.com
firstname

email2@email2.com
firstname

email3@email3.com
firstname



After:


"email1@email1.com","firstname"
"email2@email2.com","firstname ...

The file looks like this: