how to separate emails from urls in Scrapebox?

so I have a list of emails that I grabbed using Scrapebox email grabber but unfortunately Scrapebox combines Emails and Urls at the same line like this:



what I want is to clean the list and delete all the urls and keep the emails and vise versa, I heard that you can use Notpade++ to do such a thing but I don't know how to deal with it can some one help me plz ?

One way to do it is above, here's another one for Excel:
https://support.office.com/en-us/ar...s-Wizard-39f7b055-6b39-4cb5-9512-13cc19b3a807

The only difference, that you have "|" as separator, so you type that without the quotation marks in the "Other" field at the appropriate step.

Or you can simply use this tool: http://www.evil-brain.org/extractor1.4.php
But if you have too many results, it will crash the browser.

anes2010 said:

so I have a list of emails that I grabbed using Scrapebox email grabber but unfortunately Scrapebox combines Emails and Urls at the same line like this:

View attachment 79227

what I want is to clean the list and delete all the urls and keep the emails and vise versa, I heard that you can use Notpade++ to do such a thing but I don't know how to deal with it can some one help me plz ?

Click to expand...

I would use excel because thats what I know, but thats covered above. Mr. Lich has a good option as well.

But what I wanted to point out is for next time. If you just uncheck the option to save the url with the email then Scrapebox will simply save the email address by its self and you won't have to do this.

That of course doesn't help you for this time, unless its a small list then you can just reharvest it with Scrapebox and call it a day.

thanks for the help guys really appreciate it

Thats something good to learn because I have no idea about it.