Problem:
I want only those lines which include @ in it ?
Jasmeet Singh
Jasmeet Singh Singhjassu1004@gmail.com
· 16h
Vandana Gupta
Vandana Gupta vandygupta77@gmail.com
· 1h
DeVesh UDit
DeVesh UDit deveshudit@gmail.com
· 17h
Ritesh Singh
Ritesh Singh ritesh894@gmail.com
· 14h
Sarthak Vij
Sarthak Vij sarthaksv95@gmail.com
Solution in Notepad++:
This can be achieved by using Find and Replace in Notepad++.
Here is how :
^ : begining of line
[^@]+ : 1 or more character that is not @
$ : end of line
Solution in Excel :
This can be done by using text filter in excel:
I want only those lines which include @ in it ?
Jasmeet Singh
Jasmeet Singh Singhjassu1004@gmail.com
· 16h
Vandana Gupta
Vandana Gupta vandygupta77@gmail.com
· 1h
DeVesh UDit
DeVesh UDit deveshudit@gmail.com
· 17h
Ritesh Singh
Ritesh Singh ritesh894@gmail.com
· 14h
Sarthak Vij
Sarthak Vij sarthaksv95@gmail.com
Solution in Notepad++:
This can be achieved by using Find and Replace in Notepad++.
Here is how :
- Ctrl+H
- Find what: ^[^@]+$
- Replace with: EMPTY
^ : begining of line
[^@]+ : 1 or more character that is not @
$ : end of line
Solution in Excel :
This can be done by using text filter in excel:
- Select row containing data.
- Click filter.
- Select text filter then contains.
- Enter @ in contains section.
- As a result it will return all emails.