Need help with regex Email in Notepad++

Question

I have a list with contacts each line, we have to replace the whole line in to single email:

Name, Surname, Address, Email, Phone
=> Email

I know how to find email, but I need smth like find and replace to "" everything but Email

Answer 1

I don't think you can replace "everything except" any regex in notepad++. I usually use macros for such a problem.

But another method would it be, to import the data into Excel as a CSV, mark the column with the email adresses and copy-paste them to notepad++. That's another trick I usually do.

Answer 2

Assuming your email regular expression is well-written and won't match anything that isn't an email...

Find (() characters are significant):

^.*(your email regex here).*$

Replace with:

\1