how to leech email from database

such kind of database information
how can i leech email???

INSERT INTO `members` VALUES ('ds9d9', 'asdf', '$1$b2z/pCw1$O9Iwp2j6jz3QT', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('fd9d5', '555', '$1$EUZ479dK$a2xo.uH8R8IZY', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('dsf8d', 'asdf', '$1$vQic0ZVa$i6xtXMvKdNHV/', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('d3333', 'dfdfd', '$1$Z.HWa/jN$1ht5O185mGdUu', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('asd333', 'asdf3', '$1$Ibx84jTF$ahwXMyMSQmVq/', 'mousel@defend.net', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');
INSERT INTO `members` VALUES ('test', 'testpassword', '$1$ZP55yZKA$M22Bo6B3Ub/Um', 'test@test.com', '%%TRAN?', '%%REBILL?', 'y', '0000-00-00');






and those are different


INSERT INTO `members` VALUES (602, '', '', '', '', '', '', '', '', '', '', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');
INSERT INTO `members` VALUES (642, 'BrianTest', '', '', '', '', '77580', '', 'brianscook@att.net', 'brianscook@att.net', 'password', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');
INSERT INTO `members` VALUES (603, '', '', '', '', '', '', '', '', '', '', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');
INSERT INTO `members` VALUES (1039, '', '', '', '', '', '', '', '', '', '', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";username|N;passtext|N;firstname|N;lastname|N;address|N;ci ty|N;state|N;zip|N;phone|N;email|N;number|i:1;numcurved|i:0;numfront|i:0;height| a:1:{i:0;s:2:"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1 :{i:0;s:2:"no";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666 666663587648145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544 8084771633148193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor| s:5:"white";gridwork|s:2:"no";randuser|N;', '', '15285');
INSERT INTO `members` VALUES (604, 'Sam', 'Tranchina', '2802 9th Street N', 'Texas City', 'Texas', '', '', '', '', '', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');
INSERT INTO `members` VALUES (679, 'Brian', '', '', '', '', '77580', '', 'brianscook@att.net', 'brianscook@att.net', 'password', 'domain|s:15:"206.209.126.183";City|N;State|N;zipcode|s:5:"54915";howheard|s:13: "search engine";access|s:1:"y";number|i:1;numcurved|i:0;numfront|i:0;height|a:1:{i:0;s:2 :"36";}width|a:1:{i:0;s:2:"36";}totalfront|i:0;total|i:288;front|a:1:{i:0;s:2:"n o";}curved|a:1:{i:0;s:2:"no";}weight|s:2:"90";amount|d:0.68616666666666663587648 145039565861225128173828125;gridadd|d:0;cost|d:197.61599999999998544808477163314 8193359375;cost_for|s:6:"197.62";screencolor|s:5:"black";framecolor|s:5:"white"; gridwork|s:2:"no";randuser|N;calculated|N;warranty_for|N;promo|s:0:"";username|s :20:"jnit_54915@yahoo.com";passtext|s:7:"woofer1";firstname|s:3:"Jim";zip|s:5:"5 4915";email|s:20:"jnit_54915@yahoo.com";', '', '');


please help

[Worldworier]

try ultra edit

custumize your sort / search criteria

Looks like a user DB (SQL i think)
put any wamp on your system and work with the DB

[Jayman]

http://home.hccnet.nl/s.j.francke/software/software.htm

CSVed

A freeware program

Notes on the Modify Tab
You will see a section under this tab called Set Seperator. The Set Seperator is a Delimiter, or how the Fields in the database are seperated. In both your examples the databases use the comma , Symbol. Another example is that Wordlists are commonly seperated by a colon :

- Select the Comma for your Set Seperator then Open your File
- Click the Edit from the Tool Menu, Click on Repair CSV
- Click on the Save Tab
- Tick on the Columns to save, (the Columns you want to leech from, you'll need to choose the column number where the email addy is)
- Tick Use Selected Columns
- Set Seperator, click on the Other Option and type in : (a colon)
- Click on the Save Selection Button and save your leeched file.

Some further Notes

Once you've got your smaller file you may want to swap columns around

- Modify Tab
- Choose your Set Seperator, if it was the file we just Saved then we'll choose the Other Option and put in : (a colon)
- Now Open your File
- Click on the Add Column Button. This will add a Column at the End
- In the Copy Column Section, Choose the Source Column (for Example Column 1, we want to copy the first Column) and then the Target Column. Lets say this is Column 3, it will be the Column you just added.
- Click on the Copy Column Button

Now you can either Delete Column 1 and Save your File, or you can save it via the Save Tab Choosing Columns 2 and 3

[slysnake]

Nice tool, thanks Jayman

[sPlico]

New tool for me aswell. Thanks Jayman. I usually use ultraedit and stupidripper for this.

[daemon.azazel]

lol guys - you can do this in 3 minutes in MS Excel ;)

[sPlico]

How's your excel in loading 40 meg files?

[daemon.azazel]

hahahaha splico, that's right excel supports only 65536 lines,
but to be honest, all such files i processed so far were under
this so sorry for my rude notice ;)

[sPlico]

Lol, it's ok. Was just a question as i never used excel for that as it usually hung on "bigger" files on my comp, but im on win98, so i always thought that might be the problem.

thank you Jayman, it is a new tool for me