How to convert email:password to email format

  • Thread starter Thread starter Deleted member 283687
  • Start date Start date
D

Deleted member 283687

Guest
Hi guys any idea how to convert email:password to email only i dont need password field i have a big list want to convert this to email only ,if you know how to do let me know thanks
 
I'm assuming that this list is saved in .txt or other format that can be opened in text editor

1. Install notepad++
2. Open your emails file
3. Press ctrl +F and replace ":" with ","
4. Save as emails.csv
5. Open emails.csv in excel. The emails will be first column and password second. Delete password column
6. Rename to emails.txt
 
Notepad++

Find/Replace

Select regex

Find: (\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}\b)
Replace: \r\n$&\r\n
 
Hi guys any idea how to convert email:password to email only i dont need password field i have a big list want to convert this to email only ,if you know how to do let me know thanks

- If its all in one cell, just open excel
- Highlight column
- Data
- Text to columns
- Delimited
- Other ":"
- Finish

And voila, emails in Column A, password in column B for easy copy paste, or later use.


Or

- Find and replace
- Find What :*
- Replace with (leave this empty)

And done
 
thanks the excel thing worked very well i have downloaed some softwares all failed,simple excel trick worked
 
in linux:
Code:
cat list.txt | cut -d ':' -f 1 > out.txt
 
How did you guys learn regex:D:D:D
Everything is on Stackoverflow nowadays. If you need to format data, you just type what you want to do in Google and it leads to Stackoverflow, where the result often is Notepad++ and regex. You can format data using complex regex codes without knowing any regex. Nowadays you don't necessarily have to learn it or learn anything, you just need to know the right keywords to use in Google and voila. :p
 
Everything is on Stackoverflow nowadays. If you need to format data, you just type what you want to do in Google and it leads to Stackoverflow, where the result often is Notepad++ and regex. You can format data using complex regex codes without knowing any regex. Nowadays you don't necessarily have to learn it or learn anything, you just need to know the right keywords to use in Google and voila. :p
I once found this EXACT regex for extracting Amazon ASINs from URLs but have never been lucky again. The ones I get all need modifications and I suck
 
Back
Top