I have a list of about 100 people who joined my website and I am trying to send them an important email. The list of my site members looks like this.. 3 clyde 10.0.0.2 alvon@ad0main111.com 4 hakeem 10.0.0.1 money@ad0main142.com 5 rudy 192.168.1.1 tommy3fone@ad0main123.com 6 yao 10.0.0.7 pillfill@ad0main13.com3 etc.... . So it has their username, Ip address, and email. I only want their email so is there a program that I could just copy my entire list into and delete the unwanted items? What is the fastest way to get their email address alone? It would take forever to just delete everything by one. Please help me!!
I went ahead and modified your initial post as it did seem to have real people's emails and ip's. Hopefully some email harvester or Google didn't get them already for their sake (and maybe yours). If there is a space between each field (or some common character sequence), use Excel to import the file. Get rid of the columns you don't want (everything but the email column) and save it back out as a text file. You can also use a scripting language like vbscript or something and write a script to do it.
haha, too late friend! They will all wake up to a nice surprise of The Mandingo Newsletter in the morning.
That's probably the easiest way. If you don't have excel, grab a copy of Textpad and create a quick macro to do it.
